BrettOlbrys1
Board Regular
- Joined
- May 1, 2018
- Messages
- 138
- Office Version
- 365
- Platform
- Windows
I need some help to resolve my issue. I have two files, one that contains all of the raw data (about 10mb), and a dashboard file that people have access to. The raw data file grows in size every day because of the sales that happen every day, but one sheet of data may grow by 100 lines and the other sheet of data may grow by 70 lines (because two different segments of the business).
This dashboard file pulls the raw data into it, and then using lots of formulas, displays the data in a consumable format.
I have 2 issues:
1) If all of my formulas look at the columns of data, lets say $A:$AL, my file size of this dashboard file grows to 156mb (compared to the 10mb of actual data)
2) If my formulas all reference a specific range ($A$1:$AL$10000), my file size is about 7mb, but when new data is pulled into the data sheets for analysis, the formula ranges change. One range may change from $A$1:$A$10156 and another range (which references the other set of data) may change to $D$1:$D$10500. Because these ranges now have different row counts, my sheets give me an error because the ranges in the formulas are different.
Question:
How do pull data into my worksheet, from two different sources, without affecting the formulas that look at that data so that the ranges don't change AND I keep my file size small?
Thanks
Brett
This dashboard file pulls the raw data into it, and then using lots of formulas, displays the data in a consumable format.
I have 2 issues:
1) If all of my formulas look at the columns of data, lets say $A:$AL, my file size of this dashboard file grows to 156mb (compared to the 10mb of actual data)
2) If my formulas all reference a specific range ($A$1:$AL$10000), my file size is about 7mb, but when new data is pulled into the data sheets for analysis, the formula ranges change. One range may change from $A$1:$A$10156 and another range (which references the other set of data) may change to $D$1:$D$10500. Because these ranges now have different row counts, my sheets give me an error because the ranges in the formulas are different.
Question:
How do pull data into my worksheet, from two different sources, without affecting the formulas that look at that data so that the ranges don't change AND I keep my file size small?
Thanks
Brett