How to save the setting on displayi toolbar for refresh external d

[Eric]

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

 

[Eric]

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

 

[Eric]

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]

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

 

[Eric]

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