ukdane
03-02-2009, 05:26 AM
I've sent the same workbook, to a number of locations, who save the file on a local network.
The workbook is a shared workbook, with each locations workbook being used by anywhere between 1 and 12 people at any one time.
I've recently noticed that the size of the file has grown quite a bit at some locations, whilst it remains smaller at other locations. This seems to be irrospective of the amount of data that has been input into the workbook.
I've also noticed, that the time it takes for each location to save their workbook has slowed considerably. File sizes vary between 5Mb and 35Mb.
Saving times between 13 seconds, and 1 minute 23 seconds.
The workbook also contains a number of Hyperlinks, to file locations. I've tried removing the links, and it doesn't appear to have had an effect on file size, or sharing time.
Generally, saving the workbook to C drive is a few seconds (but not much) quicker than saving to the network drive.
1) How can I find out why the file sizes are varying so much?
2)Is there someway Excel can evaluate which parts of the worksheet are requiring more memory?
3) How can I reduce the time it takes to save the workbook? (I assume the answer here is reduce the file size)
I can't post the workbook, as it contains sensitive material.
I can tell you that each instance of the workbook contains 16 worksheets. So far only 7 of these worksheets contain data,
and that the "largest" of these worksheets only contains data in the fields from A1:BN400 (or there abouts). There is on average one hyperlink on each line that contains data.
Any information about the what, where, how, why's and so forth about these two fugitives is greatly appreciated.
I need to aprehend them as soon as possible :-)
Thanks
The workbook is a shared workbook, with each locations workbook being used by anywhere between 1 and 12 people at any one time.
I've recently noticed that the size of the file has grown quite a bit at some locations, whilst it remains smaller at other locations. This seems to be irrospective of the amount of data that has been input into the workbook.
I've also noticed, that the time it takes for each location to save their workbook has slowed considerably. File sizes vary between 5Mb and 35Mb.
Saving times between 13 seconds, and 1 minute 23 seconds.
The workbook also contains a number of Hyperlinks, to file locations. I've tried removing the links, and it doesn't appear to have had an effect on file size, or sharing time.
Generally, saving the workbook to C drive is a few seconds (but not much) quicker than saving to the network drive.
1) How can I find out why the file sizes are varying so much?
2)Is there someway Excel can evaluate which parts of the worksheet are requiring more memory?
3) How can I reduce the time it takes to save the workbook? (I assume the answer here is reduce the file size)
I can't post the workbook, as it contains sensitive material.
I can tell you that each instance of the workbook contains 16 worksheets. So far only 7 of these worksheets contain data,
and that the "largest" of these worksheets only contains data in the fields from A1:BN400 (or there abouts). There is on average one hyperlink on each line that contains data.
Any information about the what, where, how, why's and so forth about these two fugitives is greatly appreciated.
I need to aprehend them as soon as possible :-)
Thanks