Managing a Large Workbook

L

lucyrox

Hello,
I'm working with a very large workbook, it stretches from column A t
column BE (about 33MB) and it is divided into 13 tabs or departments.
It has both numbers and text. I have to email this out to 13 people
have them update it, and email it back to me for an annual report. M
question is how can I combine all of the information into one larg
document that shows all 13 departments? Is there some type of mergin
feature I can use? I've been looking at using the consolidate featute
but want to avoid linking if possible.

Thanks a lot
 
G

Guest

My suggestion would be this -

Create 13 different spreadsheets and one
central 'summary' spreadsheet (you have this already).
Using the s/sheet you already have copy each of the 13
sheets to a new book and save with dept.name.

Email each of these dept. s/sheets, on receipt back by
email, copy the contents of the entire sheet and paste
special values back to the 'summary' spreadsheet into the
appropriate sheet. You could do this by macro if you
wished.

This will eliminate any linking. The structure of the
distributed spreadsheets must be locked so that they
match the structure of the sheets in the 'summary'
s/sheet, otherwise formulas in the 'summary' s/sheet will
fail.

Hope this helps
Paddy
 
Top