Hello all,

I have a spread sheet that I need to store, access and edit from a network drive.

I have 6 tabs as much of the imformation need to jump around between tabs. Each tab has data and formulars for 2000rows.

I have also added in statments such as:

=if(a1="","",'Sheet2'A1)
to make the sheet look emtpy until the relevant fields are entered.

The probelm is the file size is around 40mB, which takes far too long to load, making it unrealistic to actually use.

I also have some conditional formats to keep the document colours good.

Does anyone have a suggestion about how I can decrease the file size and thus make the document more likley to work day to day.

Cheers

Ste