Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Refresh Data
I have a spreadsheet that will have 10 to 12 different data sources.
Can I refresh all the data sources at once? or do I have to do them individually? Thanks in advance |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Refresh Data
Doug,
ThisWorkbook.RefreshAll Cheers, Pete -----Original Message----- I have a spreadsheet that will have 10 to 12 different data sources. Can I refresh all the data sources at once? or do I have to do them individually? Thanks in advance |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Refresh Data
OK. That works great.
I have a follow-up situation. There might be an easier way to do this, I am not sure. I have a worksheet, that is just another XLS spreadsheet that I refresh. It was "imported". When I refresh that data, the entries that contain only numbers in a certain column do not come across. The entries that contain letters in the same column come across. They are being lost on the import. "Pete McCosh" wrote in message ... Doug, ThisWorkbook.RefreshAll Cheers, Pete -----Original Message----- I have a spreadsheet that will have 10 to 12 different data sources. Can I refresh all the data sources at once? or do I have to do them individually? Thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy Excel functions formula and auto refresh refresh | Excel Worksheet Functions | |||
Create refresh button in worksheet to refresh Pivot Table Data | Excel Worksheet Functions | |||
Refresh existing data when changed in data validation list | New Users to Excel | |||
Pivot Table REFRESH Flaw -- Saves Old Data in Selection Area AFTER REFRESH | Excel Programming | |||
Excel does not close from VB!! (when i refresh Refresh query with BackgroundQuery:=False) | Excel Programming |