how to refresh all the sheets in a workbook by macro

D

DARRELL GIBSON

Hi
I have a number of worksheets in a workbook to which i need to refresh
the information Is it possible to do it whith a simple macro??
Maybe its something as simple as refresh workbook?


thankyou in advance
 
A

AltaEgo

Do you have your calculations set to automatic? If so, Excel does the
updating for you. If not, use your [F9] key to calculate the workbook.
 

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

Similar Threads

excel external data range "failed to refresh" 0
excel external data range failed to refresh - second try 1
A Macro to Print sheets in mult w.books 2
How to base a pivot table on another pivot table? 3
Lookups - how to obtain data from a master spreadsheet into another 5
Multiple Sheets in One Workbook Sheet? 2
Expert help needed 1
Refresh some not Refresh All 1

Top