Reference sheet

[sarfarazbutt]

I was working a file where 12 sheets was adding the summary in one sheet, I delete some sheets and re-do again. I keep the same name again for sheet but all reference was become error, see below. any idea

Excel Workbook
	C	D	E
48	#REF!	#REF!	#REF!
49	#REF!	#REF!	#REF!
50	#REF!	#REF!	#REF!
51	#REF!	#REF!	#REF!
52	#REF!	#REF!	#REF!
53	#REF!	#REF!	#REF!
54	#REF!	#REF!	#REF!
55	#REF!	#REF!	#REF!
56	#REF!	#REF!	#REF!
57	#REF!	#REF!	#REF!
58	#REF!	#REF!	#REF!
59	#REF!	#REF!	#REF!
60	#REF!	#REF!	#REF!
61	#REF!	#REF!	#REF!
62	#REF!	#REF!	#REF!
63	#REF!	#REF!	#REF!
64	#REF!	#REF!	#REF!
65	#REF!	#REF!	#REF!
66	#REF!	#REF!	#REF!
67	#REF!	#REF!	#REF!
68	#REF!	#REF!	#REF!
Monthly Overview

 

[ChrisM]

The moment you delete the sheets those formulas will error out, regardless of what you do afterwards.

You need to temporarily disable the formulas before deleting and readding the sheets.

Do a find and replace:

Find: =
Replace With: #

This kills all formulas, now delete and add sheets.

Then do another find and replace:

Find: #
Replace: =