try this

go to edit | links | updates values | click startup prompt | choose
second option | ok | close


On Sep 23, 7:36*am, Dave H wrote:
When I open an excel file I get the pop up "this workbook contains links
to other data sources" I can see the data on the spread sheet but if I
choose Either update or don't update the numbers all change to #name.
Is there anyway to open this spreadsheet while retaining the values
that were there?

--
Dave H