automatic query refresh


Gorjan Kepeski


I have the following problem :

I export data from SharePopint Portal 2003 to excel and enable automatic

query refresh.

Whenever I open any of the excel files mentioned above, I have to click

enable data refresh (every time). In office XP there was a checkbox enabling

the "always do the selected operation" feature. In office 2003 there is no

such thing but I have to use it because excel XP or 2000 is incompatible

with SharePoint (as far as data refresh is concerned). How can I instruct

excel to always preform automatic data refresh and stop prompting me

everytime I open the file?

Thanx, gorjan

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question