Thread: Excel file slow
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dennis Tucker Dennis Tucker is offline
external usenet poster
 
Posts: 140
Default Excel file slow

One thing that can add to the file size and slow down your system is a
massive amount of worksheet functions. Like IF functions that are currently
returning null strings. Another possibility is that the workbook contains
links to external data(other workbooks or the internet).


"Scoop" wrote in message
...
Excel file is slow. Size of file is 1,586 KB. When I open it the task
manager reports 667,543 kb. The information is from A1 to R66 with only
one
line of Totals and one line of Percentage change from previous week.

I have copy/paste special the data into a new file with a new name, but
still the same results.

This is the only file, and near smallest, of about 50 - 60 files I work
with
regularly. It is the only file with this problem.

What is the solution? thank you