I have several worksheets with linked formulas that change on me. I go to update the worksheet and find that the formula has changed on me. They are not shared worksheets so I know no one is going in and changing them. Just wanted to know if anyone else has had a similar experience.

What type of changes are being made? EEOC

The worksheet name is being switched to another worksheet.

Please be more specific. When you say "linked formula" what do you mean? Are they linked to other workbooks or do they just reference other sheets within the same workbook? Are you using any dynamic Named ranges? Please post an example of a formula that changes and give us a little detail.

What do you mean by dynamic? Sometimes I am linking worksheets within a workbook and sometimes I am linking worksheets from two different workbooks. Example Should be: =+'O:\Investment Committee\Portfolio Performance\UST NAV\[UST MM NAV.xlsx]2009'!$H$21 I paste the above formula in a cell and save it. When I go back into the worksheet the following formula appears in the cell. =+'O:\Investment Committee\NAV Data Input\UST NAV\[UST MM NAV.xlsx]2009'!$J$21

You said: The worksheet name is being switched to another worksheet. That is not what the links that you posted show. I see 2 changes: 1 - The path has changed from 'O:\Investment Committee\Portfolio Performance\UST NAV\ to 'O:\Investment Committee\NAV Data Input\UST NAV\ 2 - The specific cell referenced has changed from $H$21 to $J$21 The filename and worksheet name remained the same. I don't have an answer, but have you looked in the 2 folders (Portfolio Performance\UST NAV\ and NAV Data Input\UST NAV\) to see if the same filename exists in both. I don't mean anything by this, but are you sure you are opening the same file each time? The fact that the path is changing but not the filename or worksheet name seems to indicate 2 files with the same name in 2 different folders. Obviously I'm just guessing here, but that's what it looks like based on the links you provided.