View Single Post
 
Old 10-10-2023, 08:08 AM
AllekieF AllekieF is offline Windows 10 Office 2021
Novice
 
Join Date: Oct 2023
Location: Netherlands
Posts: 9
AllekieF is on a distinguished road
Default

Usually this is an issue with a generally applied formatting, i.e., applied to an entire row or column. This applies formatting info to all cells in the row/column, causing Excel to think that all these cells are used (and increasing the workbook size excessively).

What happens if you copy-paste to a new sheet without formatting? Pasting column widths using the right-mouse quick menu also pasts cell formatting. Try using the actual paste-special menu, which has more options.
Reply With Quote