Hi guys,
I have an excel file on a server. Currently, this file is used by 4 users. When someone makes a change to it, all others need to close down/re-open it so that they can see the changes. Is there anyway to auto refresh this file using Excel options?
Note that, the users use MS Office 2007/2010.
Earliest thanks.
0
Excel file on the server to be shared
Started by
ITPro999
, May 23 2011 06:17 PM
1 reply to this topic
#1
ITPro999
-
- Members
-
- 216 posts
Advanced Member
- Gender:Male
- Location:London
Posted 23 May 2011 - 06:17 PM
#2
mip104
-
- Global Moderators
-
- 4028 posts
V.I.P. Member
- Gender:Male
Posted 23 May 2011 - 08:59 PM
This can be done in two ways:
1- Excel pivot tables have an option to auto refresh when the spreadsheet opens. All you need is to check the box and you are done.
2- If you run this macro in a workbook:
Sub RefreshOnOpen()
For Each pc In ActiveWorkbook.PivotCaches
pc.RefreshOnFileOpen = True
Next
End Sub
The workbook will try to refresh all external datasources. The macro needs to be run just one time and can be deleted after running.
1- Excel pivot tables have an option to auto refresh when the spreadsheet opens. All you need is to check the box and you are done.
2- If you run this macro in a workbook:
Sub RefreshOnOpen()
For Each pc In ActiveWorkbook.PivotCaches
pc.RefreshOnFileOpen = True
Next
End Sub
The workbook will try to refresh all external datasources. The macro needs to be run just one time and can be deleted after running.
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users
