J
Jim Reed
A friend has an Excel workbook that contains one overall summary worksheet, and about 20 individual worksheets that each pull data from the overall summary sheet. She asked me to help troubleshoot some problems that she was having.
What I found was that some of the 3D references had changed. Instead of looking from the individual sheet to the summary worksheet in the current workbook, the formulas were referencing a different version of the workbook that was saved in a different folder.
But this did not occur across the board. It only affected 3 or 4 of the individual sheets, but every 3D reference on the affected individual sheets had been changed.
Does anyone have an idea of what might have caused this to occur?
Thanks in advance for your help!
--
What I found was that some of the 3D references had changed. Instead of looking from the individual sheet to the summary worksheet in the current workbook, the formulas were referencing a different version of the workbook that was saved in a different folder.
But this did not occur across the board. It only affected 3 or 4 of the individual sheets, but every 3D reference on the affected individual sheets had been changed.
Does anyone have an idea of what might have caused this to occur?
Thanks in advance for your help!
--