Help with #REF! error on worksheet

[dblplanker]

Hello,

I have created a worksheet template that is saved and used monthly to
summarize data exported from another db. The cell references in the template
that correlate to the imported data never change nor do the names of the
imported worksheets.

The problem I have is when I copy my template to the new workbook with the
next months data and recalc, I still get ref errors. I have to manually
click into each cell / formula to eliminate the err and get the data. Is
there a way to have this information updated automatically when I copy my
template into the new workbook?

Thanks,

Greg Y

 

[Jim Rech]

I'm not exactly clear on why you're getting the ref error but if you find
that double clicking the formulas fixes them then you might find that doing
a Find/Replace of "=" with "=" does the same thing to all the formulas at
once.

--
Jim
| Hello,
|
| I have created a worksheet template that is saved and used monthly to
| summarize data exported from another db. The cell references in the
template
| that correlate to the imported data never change nor do the names of the
| imported worksheets.
|
| The problem I have is when I copy my template to the new workbook with the
| next months data and recalc, I still get ref errors. I have to manually
| click into each cell / formula to eliminate the err and get the data. Is
| there a way to have this information updated automatically when I copy my
| template into the new workbook?
|
| Thanks,
|
| Greg Y
|
|

 

[dblplanker]

Thank you!
That worked. I hope to find an automated method going forward but this will
work for now.

Thanks again