Data refresh on dashboard when excel file is data source<p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="" lang=EN-US><span style="font-size:small"><span style="font-family:Calibri">Hi, can anyone help?</span></span></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="" lang=EN-US><span style="font-size:small"><span style="font-family:Calibri">Is it possible to have this kind of scenario on MOSS 2007. </span></span></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="" lang=EN-US><span style="font-size:small"><span style="font-family:Calibri">I have one EXCEL workbook in doc library in which users insert and edit table data. I would like to have another workbook in which I would create pivot table and chart summarizing data from first file and I would like to display this report by excel web services on a dashboard page, but would also like to have automatic refresh of data on this dashboard. </span></span></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="" lang=EN-US><span style="font-size:small"><span style="font-family:Calibri">In every kind of solution I get unable to refresh data error.</span></span></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="" lang=EN-US><span style="font-size:small"><span style="font-family:Calibri">Please give me some advice on what should be done to have data refresh on dashboard when excel file is data source.</span></span></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="" lang=EN-US><span style="font-size:small"><span style="font-family:Calibri">Thanks in advance.</span></span></span></p>© 2009 Microsoft Corporation. All rights reserved.Mon, 29 Jun 2009 09:21:28 Z2ebb0482-6aa7-4b09-a213-8bfbd9d5e162http://social.msdn.microsoft.com/Forums/en-US/sharepointexcel/thread/2ebb0482-6aa7-4b09-a213-8bfbd9d5e162#2ebb0482-6aa7-4b09-a213-8bfbd9d5e162http://social.msdn.microsoft.com/Forums/en-US/sharepointexcel/thread/2ebb0482-6aa7-4b09-a213-8bfbd9d5e162#2ebb0482-6aa7-4b09-a213-8bfbd9d5e162Vladimir Zečevićhttp://social.msdn.microsoft.com/Profile/en-US/?user=Vladimir%20Ze%u010devi%u0107Data refresh on dashboard when excel file is data source<p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="" lang=EN-US><span style="font-size:small"><span style="font-family:Calibri">Hi, can anyone help?</span></span></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="" lang=EN-US><span style="font-size:small"><span style="font-family:Calibri">Is it possible to have this kind of scenario on MOSS 2007. </span></span></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="" lang=EN-US><span style="font-size:small"><span style="font-family:Calibri">I have one EXCEL workbook in doc library in which users insert and edit table data. I would like to have another workbook in which I would create pivot table and chart summarizing data from first file and I would like to display this report by excel web services on a dashboard page, but would also like to have automatic refresh of data on this dashboard. </span></span></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="" lang=EN-US><span style="font-size:small"><span style="font-family:Calibri">In every kind of solution I get unable to refresh data error.</span></span></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="" lang=EN-US><span style="font-size:small"><span style="font-family:Calibri">Please give me some advice on what should be done to have data refresh on dashboard when excel file is data source.</span></span></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="" lang=EN-US><span style="font-size:small"><span style="font-family:Calibri">Thanks in advance.</span></span></span></p>Mon, 29 Jun 2009 09:21:27 Z2009-06-29T09:21:27Z