Forum Discussion
Format Painter trouble.
Here is a copy of the workbook with those text boxes removed from every sheet.
I ran the doc inspector to remove my personal info from the file. In the process of doing this Excel took very long (about 5 minutes) to detect Hidden Rows and Columns.
This isn't an issue for me on my setup but it might be worth unhiding rows and columns to see how the workbook performs if you still have issues.
Doc inspector stats for hidden rows/columns:
47
Are you able to upload the workbook so I may have a look? You could even dummy out the data if it's confidential. The formatting is what I'm most interested in. Also, it could be the amount of used rows in a given worksheet. Go through the sheets and press ctrl+end. If it jumps down well past your data then there's a lot of rows in use.
Thank you, Patrick.
The file uploaded is the smallest in my set but gives the same errors.
Title:
Here is a copy of the workbook with those text boxes removed from every sheet.
I ran the doc inspector to remove my personal info from the file. In the process of doing this Excel took very long (about 5 minutes) to detect Hidden Rows and Columns.
This isn't an issue for me on my setup but it might be worth unhiding rows and columns to see how the workbook performs if you still have issues.
Doc inspector stats for hidden rows/columns:
- Hectic life ... but this looks good.
I'll see about cleaning my other files.
Many, many thanks to all hands here!
From what I've looked at most of the sheets contain unused text boxes that can be removed.
Home | Find and Select | Selection Pane will reveal them. Press Ctrl+A to select all then tap delete.
See how the workbook performs once those are removed from all sheets. BTW the workbook didn't give my computer any trouble.
Here's what the selection pane shows for most sheets:
I only tried to unhide rows in very first sheet and it hangs. So far have no idea why. No problems with coupe of other sheets.
