#Ref error does not gets fixed even after fixing

Sarathi_57

Banned
Joined
May 2, 2012
Messages
3
Reaction score
0
Points
0
#Ref error does not gets fixed even after fixing

Hi,

I am having a workbook 'Test.xlsx'. This workbook has many formulas that link to another workbook "Data.xlsx". For some reason, every month the worksheet name in the Data.xlsx changes and the cells in the Test.xlsx shows as #ref in the formulas wherever it is referring to the worksheet "Data.xlsx".

What i did was, I find and replaced the #ref with the valid worksheet name and now the data is populated correctly without the #ref.

Here comes the problem, when i save the workbook and when i re-open the workbook, it still shows the #ref in the formulas. whatever change i did in replacing the #ref to valid worksheet names are not appearing.

I have checked many forums and i am not able to fix this.

Your help is much required, please do suggest me some solutions

Thanks
Sarathi
 

Bob Phillips

Super Moderator
Staff member
Joined
Mar 21, 2011
Messages
1,940
Reaction score
0
Points
36
Excel Version(s)
O365
What formula?
 
Top