I am new to the forum, and consider myslef a novice user of Excel, and need the experts to help me out. I have been stumped by a workbook that is relatively simple, one tab with data 7 others with charts; 30-days of data only.
The workbook keeps growing and growing. Up to 9mb. Searched this site for advice on how to triage the problem; tried everything. Last resort was I deleted all spreadsheets in the workbook except the data tab. Then I deleted all columns and rows, cleared all columns and rows in the remaining tab. Now I have one blank spreadsheet in a workbook; no hidden columns, no hidden rows, no hidden sheets. The file is now 8.77mb. How can that be?????