I have had an Excel 3 worksheet workbook biweekly
timesheet going for a number of years. One worksheet
provides a 'by period' schedule of leave used and
accrued, and the next two worksheets are identical,
except one is for the current period and the other is for
the prior period. The individual workbooks are created,
maintained and 'rolled' from period to period using VBA
macros (maintained in a separate Excel workbook). Error
corrections and enhancements are also posted to the
timesheet workbooks using VBA macros.

Once we 'upgraded' to Excel 2003, Excel has started
modifying the named formulas by including the sheet name
on cell references in the formulas. Since 2 workbooks
are identical as to structure, adding the sheet name to
cell references in formulas has required me to duplicate
all formulas - one set specific to each worksheet. Also,
formulas that cross between sheets can have the other
worksheet name replaced by the workbook name, which
causes a #NAME error.

How do I keep Excel 2003 from altering the Named formulas
I create?