Links in Excel Keep Changing

June 9, 2009 at 07:36:15
Specs: Windows 2007
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.

See More: Links in Excel Keep Changing

Report •

June 9, 2009 at 08:25:10
What type of changes are being made?


Report •

June 9, 2009 at 08:28:54
The worksheet name is being switched to another worksheet.

Report •

June 9, 2009 at 08:53:48
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.

Report •

Related Solutions

June 9, 2009 at 09:14:26
What do you mean by dynamic?

Sometimes I am linking worksheets within a workbook and sometimes I am linking worksheets from two different workbooks.


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

Report •

June 9, 2009 at 10:02:25
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\


'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.

Report •

Ask Question