Hello,
I am a proficient Microsoft Excel user. I've recently joined a new company and am making a running file that contains historical sales data. The file, at this point, is 130,000 lines long and contains 26 columns of data (26 columns "wide" x 130,000 rows "long"). This file runs very slow and takes a long time to calculate.
I have deleted out any formulas by copy/pasting values over the entire block of data. What other efforts can I make to help speed the processing time of this file? Again, it takes a very long time to open, and any changes made to the data put my newer computer on the verge of shutting down.
Please help!
Thanks,
Georgia
Bookmarks