![]() |
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 |
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 |
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 |
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 |
All times are GMT +1. The time now is 08:24 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com