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