Making Spreadsheet Run Smoother

[Kurt_v]

I have been tasked by managment to make out spreadsheet that is used for pretty much everything run smoother (currently they take forever to save, freeze often, ect). Currently there is one workbook per sales team, with each team averaging 11 sales reps. Each rep has their own tab/sheet and then there is a data dump tab. The average size of each work book is 11/10 MBs. Of course my limitation is I cant get rid of any of the data on the spreadsheet.

I think the reason they are running so poorly is most of the data on each reps tab comes via a vlookup.

So my question is will they run any quicker if I give each rep their own seperate workbooks and have them all access the data dump which would be another seperate workbook?

I need to make sure that the data dump only has to be update once and will automatically update the reps spreadsheet.s

If this is confussing let me know and I will explain it in a different manner.

Thanks for the help.

-Kurt

[Mallycat]

lots of formulas = slow and cumbersome. It sounds like a job for more of a database approach rather than vLookup. A pivot table over the source data may work well. It's too hard to say without seeing the data.