hello,
I have a giant file, 13.9MB created in the excel latest version. It has a total of 4 tabs. The first and second tabs have a total of 88 charts, the third tab run a Vlookup formula in a single row; it has a total of 7713 rows raw data running from column A to column CW. The last tab has 10 rows running a Vlookup formula and 7713 rows of raw data run from column A to column CW again. The problem is when I click on the charts, it take about 30 seconds to take effect and sometime even frozed my pc. I tried to trim the memory by not having too much formulas and saved it in the 97-03 version, which it didnt work. Is it a way to fix this problem? Thank you for any suggestions that really appreciate it.
Happy Halloween!
Microsoft Office