ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Refresh Data (https://www.excelbanter.com/excel-discussion-misc-queries/132967-refresh-data.html)

JJ

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

Dave Peterson

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

JJ

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


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