I'm hoping someone can help me out. I am using Excel 2003 and we have a
workbook with several worksheets on it. The first worksheet "Data_Import"
is a hidden worksheet that we populate data on from an external tool. Our
second sheet "Summary" has linked cells to all of the appropriate fields on
"Data_Import". We run our external tool and it populates the Data_Import
sheet as expected but when it's opened, nothing is refreshed on our screen.
We have to either F2 on of of the cells and hit enter or we have to do a save
as for the sheet to refresh. I've tried eveything and nothing seems to work.
I have a macro running on the open event so that it hides the Data_Import
sheet as well as another sheet and I even tried adding a find/replace
function in there to run with = to trigger the refresh and nothing. These
are only linked cells, no forumals. I have auto calculation on and module1
in VBA is set to UpdateLinksAutomatic and still no luck.

Your help is much appreciated, I've been researching for 2 days with no luck.

Thanks,
Steph