CODEWITHSUNDEEP
excelexcel-2010vba
Jelovac
Jelovac

Reputation: 138

Saving large excel files issue

An excel file (about 90 MB) is a program with around 1300 Sheets with formulas and VBAs. As file is getting bigger, I have sometimes problem with saving it. It says: "Document not saved!" And I can't also save it to another location or name, because Meni: "File" is not responding. I often lose many work that I did. I have 8GB of RAM memory. Is there something that can be done to increase stability or what else to solve my issue?

Upvotes: 0

Views: 3259

Answers (1)

Reenactor Rob
Reenactor Rob

Reputation: 1526

Try using Save As-> Excel Binary Workbook.

Spreadsheet1.com-Binary excel workbook

Upvotes: 3

Related Questions