This morning, Excel is pegging out at 100% of CPU usage. Things as simple as adding a row are taking more than a minute to execute.
One other strange thing is every time I save the workbook as XLSX I'm warned that I will lose the macros. From what I see, there are no macros. (Yes. This spreadsheet was sent to me to work on. Someone else built it.)
Might these issues be related?
Using Excel 2011 for Mac
Mac OS X 10.6.8
Check the last used cell (End Home) on each sheet. You may find a formula or value has been copied down to row 1048576.
Regards
Richard Buttrey
If this was useful then please rate it appropriately.
Click the small star iconat the bottom left of my post.
I'm home now and tried the file on my PC. The CPU isn't pegging out at 100% but when it opens, there are numerous windows that say that the "File Was Able To Open By Repairing Or Removing Unreadable Content."
Still, it's taking a painfully long time to do simple Copy/Paste
If I even scroll a little, the screen freezes and on the bottom of the window it's showing "Calculating: _%" and slowly counts up to 100%
Have you checked for the last used cell on each sheet as I suggested?
Richard Buttrey
If this was useful then please rate it appropriately.
Click the small star icon
Yes. Cell AD244 is the last cell and it's what would be expected.
I checked another page.
The final cell is AA32624 but the final visible cell is U13. I can't see that there's a formula are anything going on in AA32624
Last edited by Habanero Time; 01-09-2012 at 01:03 AM.
Select rows 14 to 32264 and delete them. Save and close the workbook and then re-open.
Check all pages in a similar fashion.
Is that any better?
Richard Buttrey
If this was useful then please rate it appropriately.
Click the small star icon
I just deleted those rows and I could tell because whomever created this document had no grid lines until row 32264.
Gridlines now start at row 14 and the sheet is still showing AA32264 as the last cell.
A second attempt to delete the rows was successful.
I noticed one other thing. Above the columns is something I haven't seen before. On other spreadsheets I've seen this along the side by the rows for subtotals but never seen it above the columns before. Here is a screenshot:
http://dragoncookies.com/wp-content/...creenExcel.png
That is the Grouping symbol - you can group rows or columns or both.
If there is no code and no modules in the workbook, you should not get an error about macros being removed when saving as xlsx. Are you sure there is no code behind the worksheets? It might well explain the slowness?
Good luck.
One other thought, have you checked the size of the file lately? Sometimes files can grow into hugh unwieldy files.
To reset the last cell I have always found this useful
HTH
Regards, Jeff
If you like the answer(s) provided, why not add some reputation by clicking the * below
Please use [ Code ] tags when posting [ /Code ]
Please view/read the Forum rules --- How to mark a thread as solved
After you deleted the rows and then saved the file you should find that the last used cell is on row 13. If it's still showing row 32264 then you haven't successfully deleted the rows.
Select all the rows, by that I mean select all the row numbers 14 to 32264 and then delete. Immediately save the file and then check for the last used cell.
Regards
Richard Buttrey
If this was useful then please rate it appropriately.
Click the small star icon
Thanks for hanging in here with me. I've deleted the rows completely.
On my PC, when I open this file, I says that it Repaired or Recovered ... in order to open.
I click on the link provides afterward and it says:
Removed records: Protection from /xl/ worksheets/sheet3. xlm part
So has that fixed the problem?
When you do an End Home on any sheet to find the last used cell, are you now seeing something that seems sensible rather than a row in the 100's of 1000's?
Richard Buttrey
If this was useful then please rate it appropriately.
Click the small star icon
The problem continues.
All of the final cells do make sense.
File size of 307KB
Are you sure there is no code behind the worksheets?
Good luck.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks