Forum Discussion
Problems with pivot sum columns e file weight
1) The "used range" of most of the sheets was far too large. I deleted the unused rows and columns, and now the workbook is only 302 KB - see attached.
2) This is too complicated for me to investigate, sorry.
HansVogelaar how i can deleted the unused rows and columns? i tried but i was unsuccessful
Scroll down to the end of the data.
Select all rows from the first unused row down to the bottom of the worksheet.
On the home tab of the ribbon, select Delete > Delete Sheet Rows.
Scroll to the right to the end of the data.
Select all columns from the first unused column to the right edge of the worksheet.
On the home tab of the ribbon, select Delete > Delete Sheet Columns.
Repeat for each sheet.
Save, close and reopen the workbook.
- Unfortunately I tried to do so with a second file that is the same but with some data plus, however it does not lighten.
I'd have to see the workbook.