Hi,

I am running a workbook with about 30 pages with approx 400 rows of
data per page, and approx 15 colums per page. Each row has 15 formulas
which all correspond to the same cell in that row eg:
if c51=x,b51,0
if c51=y,b51,0
etc

Each page has the same number of formulae in the same postion.

Is there a way of writing in the formulas into the workbook so they
apply to the same cells on every page?
Would this reduce the overall size of the workbook?(currently around
5MB)

Secondly, if the first workbook is linked to a second workbook, can it
updat the information between the two without them both being open? or
is there a way to open the second workbook periodically to update
through the use of a button placed on the spreadsheet page?

i hope this is clear

thanks for any advice

Matt