CODEWITHSUNDEEP
vbaexcel
Jack Huang
Jack Huang

Reputation: 531

Excel "phantom" data: 600KB used by empty cells

I have a macro-enabled Excel workbook that is ~1.5 MB in size. After progressively deleting sheets one by one, I found that ~600 KB was used in one specific sheet, even after all VBA, buttons, and visible data was cleared.

Specifically, if I delete rows 8-1200 via selecting the rows, right-click, "Delete", save, then 600 KB disappeared from the filesize. However, if I merely stripped formatting and cell contents/values from those same rows (select rows, set formatting options to Automatic, hit [Del] key, save), the 600 KB still remained.

What could be taking up the 600 KB?

Upvotes: 2

Views: 405

Answers (1)

Safa_Alrawi
Safa_Alrawi

Reputation: 21

please check the following.. and may help

  • number of sheets used (sheet1, sheet2.. etc)
  • any equation formula may used during previous work
  • formats of cells
  • security cells or sheet..etc

thanks

Upvotes: 1

Related Questions