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:
1. Press alt+F11 to open Visual Basic editor
2. Go to View and make sure Immediate window is displayed at the bottom
3. Enter the following the immediate window then press enter:
? activeworkbook.Styles.Count
This will tell you how many cell styles are in your workbook. A blank workbook starts with 47 built-in. If you're in the 10s of thousands that's likely the causes of the issue.
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:
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: