Auto-update of Excel files under WSS

Hi all,

If I open one of the predefined Team Project .xls documents (for example "/Documents/Project Management/Scenarios.xls") modal dialog "Please wait, retrieving data from server..." is appeared and document updates imported work items automatically.
But if I import work items to the Excel document and add .xls file to the Project Portal, data aren’t updated automatically.

Is there a way to update Excel sheet while opening from the Project Portal automatically?

Thank you,
Felix.

[524 byte] By [FelixVerbitsky] at [2007-12-17]
# 1
Hi Felix,

I haven't tried this, but it should be possible to write a macro that:
- Wait for the Excel file to open
- Places the selection in a list object
- 'Clicks' the Refresh button

Let me know if you get it to work.

Thanks,
-Siddharth

SiddharthBhatiaMSFT at 2007-9-9 > top of Msdn Tech,Visual Studio Team System,Team Foundation Server - General...

Visual Studio Team System

Site Classified