Using formulas in Excel

[Matt]

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

 

[Nuge]

Should be able to get the formulas on each sheet by selecting all the
sheets prior to writing the formula.
Hold the shift key down and click on the sheets you want to have
together.
When you link data together on different work bookes when you open the
parent it should prompt you to update the data, generally speeking you
will want to say yes.