I have what I hope is not a stupid question. I have been upgrading worksheets with new formula’s, etc to capture data in more efficient manner and to avoid out-of-memory messages. I have updated 12 worksheets in a separate workbook as I did not have enough memory to update and experiment with worksheets in the production workbook.
I have 12 sheets, one for each month. The worksheets are named: Jan, Feb, Mar, Apr, etc. In the production workbook the same sheets already exist. What I want to do is basically replace the Jan sheet in the production workbook with the newly developed Jan worksheet. I want to do this for each month. Other worksheets in the production workbook reference cells in the twelve worksheets that are to replaced.
Can I “replace” the twelve worksheets without EXCEL creating error messages in all formulas that reference cells in the 12 sheets? For example, I have tried to copy the new ones into the production workbook and Excel re-names then to Jan(2) to distinguish from the original Jan worksheet already in the workbook. But when I delete the original Jan worksheet and rename the Jan(2) worksheet to Jan—the formulas that referrenced cells in the original Jan worksheet still have an error…is there a way to “trick” Excel and actually “replace” a worksheet in a workbook where other sheets in the workbook have formulas that reference cells in the worksheet that is to be replaced?
One other piece of information that I was justed advised to……Is that the employee’s PC that I need to “replace” these worksheets now has EXCEL 2007 and I have developed the new worksheets in Excel 2002. Not sure if this variation will be a cause for a different response to my question. THANKS.
