 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
.NET Forum / Visual Studio.NET / VS Tools for Office / April 2006Refreshing the data in a shared workbook with VSTO
We have an Excel 2003 workbook, automated with VSTO, on a shared network drive. The workbook contains pivot tables that refresh from live database data when the user clicks a button. It takes about 10 minutes to refresh all the data. The 30 or so users who will look at the pivot tables each day have read-only access. We have an administrator who has read/write access and performs daily maintenance tasks. We would like to implement an automatic process that will update the workbook about twice a day at specified times. How should we go about accomplishing this? several approaches come to mind from both inside and outside VSTO. Outside, you can use a thread or a timer to force an update. From inside you can take advantage of the querytable object. The object has an automatic refresh property and takes a filepath or url as the datasource. Finally, you can connect your datasource to a dataobject and have the dataobject be responsible for replenishing itself at regular intervals. Lots of choices here...  Signature________________________ Warm regards, Alvin Bruney [MVP ASP.NET] [Shameless Author plug] The O.W.C. Black Book with .NET www.lulu.com/owc, Amazon Professional VSTO.NET - Wrox/Wiley 2006 ------------------------------------------------------- > We have an Excel 2003 workbook, automated with VSTO, on a shared > network drive. The workbook contains pivot tables that refresh from [quoted text clipped - 8 lines] > workbook about twice a day at specified times. How should we go about > accomplishing this? Thanks for the suggestions! It looks like all of them require keeping an instance of Excel running at all times, presumably on a user workstation (we wouldn't want to have Excel running on the file server)! Are there any that don't? I'm looking for a batch file or executable that I can run as a scheduled task. It does not. For instance, with the datasource, you can set the option to refresh data only when the workbook is opened. At that point, data is refreshed on demand. Signature________________________ Warm regards, Alvin Bruney [MVP ASP.NET] [Shameless Author plug] The O.W.C. Black Book with .NET www.lulu.com/owc, Amazon Professional VSTO.NET - Wrox/Wiley 2006 ------------------------------------------------------- > Thanks for the suggestions! > [quoted text clipped - 4 lines] > Are there any that don't? I'm looking for a batch file or executable > that I can run as a scheduled task. Hi Alvin, Thanks for the reply. Having the data automatically update when the user opens a copy of the workbook doesn't solve the problem. We need have the data already refreshed before the user opwens a copy of the workbook. The reason is that we have about 30 users, and it takes about 10 minutes to refresh all the data. The users can't wait ten minutes for the refresh, we can't afford to devote 10 hours a day of prouction server time to these updates, and we don't want to give the users write access to the shared workbook. --Howard -- Free MagazinesGet these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...
|
Reply to this Message
|
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.