ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Shared workbook file size becoming very large (https://www.excelbanter.com/excel-discussion-misc-queries/156027-shared-workbook-file-size-becoming-very-large.html)

Phrank

Shared workbook file size becoming very large
 
I've got a shared workbook with 5 tabs. Each tab has about 20 columns
of data. Four of the five tabs have a maximum of 50 lines, and the
fith tab does have about 750 lines at the moment. The file size has
ballooned to about 40 mb, which is making it take an inordinate amount
of time to save and calculate. One of the columns is for Notes, and
the notes can get lengthy. Would this text in cells make the file
this big, or does it have something to do with the shared workbook
aspect? Is there a way to 'clean up' a shared workbook? Thanks for
any advice.

Frank


All times are GMT +1. The time now is 01:35 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com