Results 1 to 2 of 2

Thread: #Ref error does not gets fixed even after fixing

  1. #1

    #Ref error does not gets fixed even after fixing

    Register for a FREE account, and/
    or Log in to avoid these ads!

    #Ref error does not gets fixed even after fixing


    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


  2. #2
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Excel Version
    What formula?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts