Forum Discussion

D_R_Spires's avatar
D_R_Spires
Copper Contributor
Mar 03, 2020
Solved

Format Painter trouble.

I have a number of rather large Excel files (100+ Worksheets with large banks of hidden cells and extensive individual cell-formatting).   For a while I could paste in the formatting required for t...
  • Patrick2788's avatar
    Patrick2788
    Mar 05, 2020

    D_R_Spires 

    SergeiBaklan 

     

    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:

     

Resources