Skip to main content
SharePoint

Return to Question

removed thanks-message
Source Link
edit approved Jun 29, 2012 at 8:26
BenCes
edit approved Jun 29, 2012 at 8:26
BenCes
  • 357
  • 3
  • 18

I am working with SharePoint 2010. I used an Excel Web Access web part to display an Excel Spreadsheet. So that the spreadsheet can be opened in Excel and people can do editing.

However, every time when people save the changes and refresh the web page, the data in the excel spreadsheet won't be updated or reloaded. We have to manually click "File" --> "Reload Workbook".

I don't know if there is a way to do some sorts of "Automatically reload the workbook when refreshing the page". That is the major stuff I am looking for. I have been searching on the Internet. Seems like many people are asking the same stuff. But there is no any easy and clear solution.

Can anyone help me out?

Thanks a lot.

I am working with SharePoint 2010. I used an Excel Web Access web part to display an Excel Spreadsheet. So that the spreadsheet can be opened in Excel and people can do editing.

However, every time when people save the changes and refresh the web page, the data in the excel spreadsheet won't be updated or reloaded. We have to manually click "File" --> "Reload Workbook".

I don't know if there is a way to do some sorts of "Automatically reload the workbook when refreshing the page". That is the major stuff I am looking for. I have been searching on the Internet. Seems like many people are asking the same stuff. But there is no any easy and clear solution.

Can anyone help me out?

Thanks a lot.

I am working with SharePoint 2010. I used an Excel Web Access web part to display an Excel Spreadsheet. So that the spreadsheet can be opened in Excel and people can do editing.

However, every time when people save the changes and refresh the web page, the data in the excel spreadsheet won't be updated or reloaded. We have to manually click "File" --> "Reload Workbook".

I don't know if there is a way to do some sorts of "Automatically reload the workbook when refreshing the page". That is the major stuff I am looking for. I have been searching on the Internet. Seems like many people are asking the same stuff. But there is no any easy and clear solution.

Can anyone help me out?

edited tags
Link
Stu Pegg
Stu Pegg
  • 4.6k
  • 7
  • 49
  • 91
Post Migrated Here from stackoverflow.com (revisions)
Source Link
Xu Yin
Xu Yin

SharePoint 2010 Excel Web Access "Automatically reloading workbook"

I am working with SharePoint 2010. I used an Excel Web Access web part to display an Excel Spreadsheet. So that the spreadsheet can be opened in Excel and people can do editing.

However, every time when people save the changes and refresh the web page, the data in the excel spreadsheet won't be updated or reloaded. We have to manually click "File" --> "Reload Workbook".

I don't know if there is a way to do some sorts of "Automatically reload the workbook when refreshing the page". That is the major stuff I am looking for. I have been searching on the Internet. Seems like many people are asking the same stuff. But there is no any easy and clear solution.

Can anyone help me out?

Thanks a lot.