PDA

View Full Version : #Ref error does not gets fixed even after fixing



Sarathi_57
2012-05-02, 07:46 PM
#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
2012-05-02, 08:11 PM
What formula?