Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,670
Default How to save the setting on displayi toolbar for refresh external d

Does anyone have any suggestions on how to save the setting on displaying
toolbar for refresh external data? Whenever I close Excel and re-open it, the
toolbar for refresh external data is gone, and I have to manually add this
tools everytime I open Excel, does anyone have any suggestions on how to save
the last setting for toolbars?
Thanks in advance for any suggestions
Eric
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,670
Default How to save the setting on displayi toolbar for refresh external d

you can set auto refresh after open workbook
select " external data range properties" and check refresh on file open


"Eric" wrote:

Does anyone have any suggestions on how to save the setting on displaying
toolbar for refresh external data? Whenever I close Excel and re-open it, the
toolbar for refresh external data is gone, and I have to manually add this
tools everytime I open Excel, does anyone have any suggestions on how to save
the last setting for toolbars?
Thanks in advance for any suggestions
Eric

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,670
Default How to save the setting on displayi toolbar for refresh extern

Thank you very much for suggestions
I require to update the external data manually many time, once the file is
opened.
Therefore, the button for manually updating the external data is important
to me.
Do you have any suggestions on how to save the setting to display the
toolbar for external link for data update?
Thank you very much for any suggestions
Eric

"Eric" wrote:

you can set auto refresh after open workbook
select " external data range properties" and check refresh on file open


"Eric" wrote:

Does anyone have any suggestions on how to save the setting on displaying
toolbar for refresh external data? Whenever I close Excel and re-open it, the
toolbar for refresh external data is gone, and I have to manually add this
tools everytime I open Excel, does anyone have any suggestions on how to save
the last setting for toolbars?
Thanks in advance for any suggestions
Eric

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6
Default How to save the setting on displayi toolbar for refresh extern

hello
i use excel 2003 i can save tool bar status. but i don't know Why your
Can't
"Eric" wrote:

Thank you very much for suggestions
I require to update the external data manually many time, once the file is
opened.
Therefore, the button for manually updating the external data is important
to me.
Do you have any suggestions on how to save the setting to display the
toolbar for external link for data update?
Thank you very much for any suggestions
Eric

"Eric" wrote:

you can set auto refresh after open workbook
select " external data range properties" and check refresh on file open


"Eric" wrote:

Does anyone have any suggestions on how to save the setting on displaying
toolbar for refresh external data? Whenever I close Excel and re-open it, the
toolbar for refresh external data is gone, and I have to manually add this
tools everytime I open Excel, does anyone have any suggestions on how to save
the last setting for toolbars?
Thanks in advance for any suggestions
Eric

  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,670
Default How to save the setting on displayi toolbar for refresh extern

I am using Excel 2003 too, do you have any suggestions?
Thank you very much for any suggestions
Eric


" wrote:

hello
i use excel 2003 i can save tool bar status. but i don't know Why your
Can't
"Eric" wrote:

Thank you very much for suggestions
I require to update the external data manually many time, once the file is
opened.
Therefore, the button for manually updating the external data is important
to me.
Do you have any suggestions on how to save the setting to display the
toolbar for external link for data update?
Thank you very much for any suggestions
Eric

"Eric" wrote:

you can set auto refresh after open workbook
select " external data range properties" and check refresh on file open


"Eric" wrote:

Does anyone have any suggestions on how to save the setting on displaying
toolbar for refresh external data? Whenever I close Excel and re-open it, the
toolbar for refresh external data is gone, and I have to manually add this
tools everytime I open Excel, does anyone have any suggestions on how to save
the last setting for toolbars?
Thanks in advance for any suggestions
Eric



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to save the setting on displayi toolbar for refresh external d Eric Excel Discussion (Misc queries) 0 February 25th 09 02:23 AM
Auto-refresh external data? nyrblue2 Excel Discussion (Misc queries) 0 July 24th 07 04:50 PM
External data refresh Texas Tonie[_2_] Excel Discussion (Misc queries) 1 April 17th 07 11:02 AM
External Data Refresh on save problem RGS Excel Discussion (Misc queries) 0 May 8th 06 01:36 AM
external data refresh shoreguy Excel Discussion (Misc queries) 0 March 7th 06 06:30 PM


All times are GMT +1. The time now is 01:12 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"