I've got 4 sheets with feeds from a db (via network), containing 67k+ links,
and 6 sheets with over 10k cells with formula that mostly link to the first 4
sheets. We plan to have a lot of these calcs on the network eventually. At
present however, it seems that the formula pages are taking up most of the
space.
"bj" wrote:
How many of the calculations are dynamic? could you use one dynamic program
to do any calculations and a second for data transmittal with only those
calcs which absolutely have to be done over the network.
"Troy Emery" wrote:
I've a workbook approaching the 10Mb mark, which is causing speed & therefore
usability issues over our network. It consists mainly of links & formulae (I
have already deleted all the macros). Has anyone got any tips or ideas on
how to reduce the size of the file?
|