Hi

i am using the following formulae in my spreadsheet.

=IF('Pivot YTD'!B$6="","",'Pivot YTD'!B$6)

This is used in a number of cells, but the letter alters
sequentially

i.e

=IF('Pivot YTD'!c$6="","",'Pivot YTD'!c$6)
=IF('Pivot YTD'!d$6="","",'Pivot YTD'!d$6)
=IF('Pivot YTD'!e$6="","",'Pivot YTD'!e$6)

and so on

I have set up some code to create the pivot tables that i
use, but when the spreadsheet closes, these pivots are
deleted to reduce size. When i open the report again, the
above formulae contain REF! where the cell addresses
should be. Is there a way of :

a) stopping this
b) using vb to insert the formulae again using r1c1

TIA

Nathan.