Linked cells not refreshing


S

Steph C

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
 
Ad

Advertisements

P

Paul C

My guess would be that the Import routine is turing off screen updating
and/or automatic calculation and not turning them back on

in VBA the line
Application.ScreenUpdating = True
will turn screen updating back on and
Application.Calculation = xlCalculationAutomatic
will reset the calculation to Auto

Try running these as a seperate macro and if it solves the problem put them
at the end of the import routine.
 
Ad

Advertisements

S

Steph C

This worked, I added the Application.Calculation = xlCalculationAutomatic and
it's working now as expected. Thank you so much for your assistance!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top