Excelerometer
New Member
- Joined
- Aug 27, 2013
- Messages
- 12
Originally I had a large sheet (named MASTER LIST) and an analysis sheet (named ANALYSIS). The Master List ended up with the million plus rows issue that I could not resolve. To address this problem, I copied and pasted into a new sheet (named LIST) my entered data plus a few thousands rows for future entries. I would like to remove the over-sized Master List so the file is smaller and runs faster; however, I cannot figure out to change the formulas in the Analysis page to reference the LIST sheet instead of the Master List. There are SEVERAL formulas, many of which reference the Master List multiple times within the formula itself.
I have tried the following:
1. On the Analysis sheet, selected Find & Replace, tried to replace "MASTER LIST" with "LIST". This did not work, I get the NAME? error.
2. I also tried just swapping the names of the sheets (turned List into Master List after renaming the original Master List to something else), but that clearly was not a solution.
I have tried the following:
1. On the Analysis sheet, selected Find & Replace, tried to replace "MASTER LIST" with "LIST". This did not work, I get the NAME? error.
2. I also tried just swapping the names of the sheets (turned List into Master List after renaming the original Master List to something else), but that clearly was not a solution.