I have a Excel spreadsheet that I have exported from Crystal Reports so
that I can add more data and perform some calculations.

I have written VBA to do all of this but when I open the Excel and
launch the macro I get this Update Value message and have to open the
linked Excel file for each reference to it in the VBA. Everything
works just fine AFTER you open the file 48 times!!

What can I do so that the user just opens the spreadsheet runs the
macro and gets the completed spreadsheet?

TIA,

Paul