0

I have a shared Excel file with 14 people having access. The spreadsheet has been fine for a while, however, in the last 2 weeks, opening and saving the spreadsheet hangs for a good 4 to 5 minutes. Any ideas how to solve this problem?

Excellll
  • 12,847
user477894
  • 1

2 Answers2

1

Shared excel sheets tend to grow to significant size as more and more revisions get put in. I've had success in shrinking them back to a manageable size by turning off shared edit mode and saving and then turning shared edit mode back on.

Adam Bumpus
  • 21
0

I have resolved this problem with a macro here. I also have my sheets force macro use by hiding the sheets unless macros are enabled.

How do you prevent corruption of shared Excel files?

Matt
  • 286