| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Refresh Data
I inported data in a Exel worksheet and saved as .CSV file. When I re-open
this file and try to do refresh data, the refresh data button is not on. how can i refresh data for my file? thanks -- JJ |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Refresh Data
Once you saved that file as a .csv file, any query you had was lost--were you
writing about Data|Import External Data? If not, you may want to explain more. JJ wrote: I inported data in a Exel worksheet and saved as .CSV file. When I re-open this file and try to do refresh data, the refresh data button is not on. how can i refresh data for my file? thanks -- JJ -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Refresh Data
Thank Dave,
Yes. I was writing about Data|Import External Data. If I want to do refreshing data, what kind of file I should saved to? -- JJ "Dave Peterson" wrote: Once you saved that file as a .csv file, any query you had was lost--were you writing about Data|Import External Data? If not, you may want to explain more. JJ wrote: I inported data in a Exel worksheet and saved as .CSV file. When I re-open this file and try to do refresh data, the refresh data button is not on. how can i refresh data for my file? thanks -- JJ -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Refresh Data
I would think you'd want to keep the excel file as a real excel file (*.xls).
Then you could refresh the query when you know the csv file changes. JJ wrote: Thank Dave, Yes. I was writing about Data|Import External Data. If I want to do refreshing data, what kind of file I should saved to? -- JJ "Dave Peterson" wrote: Once you saved that file as a .csv file, any query you had was lost--were you writing about Data|Import External Data? If not, you may want to explain more. JJ wrote: I inported data in a Exel worksheet and saved as .CSV file. When I re-open this file and try to do refresh data, the refresh data button is not on. how can i refresh data for my file? thanks -- JJ -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I 'Enable Automatic Refresh' for Query Refresh by default | Setting up and Configuration of Excel | |||
| Refresh Data | Excel Discussion (Misc queries) | |||
| Refresh existing data when changed in data validation list | New Users to Excel | |||
| Query Refresh-Enable Automatic Refresh Dialogue Box | Excel Discussion (Misc queries) | |||
| Importing Data & Refresh Data Problem | Excel Discussion (Misc queries) | |||
Linear Mode
