I am using Excel 2007. I have a file containing over 5,000 rows, each with a few calculations. Over the last week or so it has been very slow to open and very slow to save (15 seconds). This has only been happening recently. Assuming that it was the large number of calculation which had to be performed I Copy/Paste Valued something like 5,000 rows to remove most of the formulas but it made no difference. What is my problem? Is it simply the size of the file?
Bookmarks