Added a sheet from a different workbook, still getting "Update Values" Dialogue Box

[UncleBajubjubs]

Hello, I copied over a worksheet from 1 workbook to a more comprehensive one. In this copied worksheet, I've tried to have some cells automatically calculate based on the other worksheets. For instance Cell A1=CustomerName, where CustomerName is a named cell elsewhere in the workbook.

However, typing =CustomerName into the cell open up a dialogue box saying "update Values" and asks me to select a file. I'd rather it just automatically took the value currently in the workbook, but don't know how to make it do this. Thanks.

 

[JazzSP8]

Hi

Sounds like you've still got a Formula referencing something in the old workbook. You can check on these connections by going to the 'Data' tab and looking under 'Connections', you should be able to see where the problem lies there.

HTH

 

[UncleBajubjubs]

I checked the Connections, and do not see any items listed. Thank you though.