Jump to content

Excel file on the server to be shared

  • Please log in to reply
1 reply to this topic

#1 ITPro999


    Advanced Member

  • Members
  • PipPipPip
  • 216 posts
  • Gender:Male
  • Location:London

Posted 23 May 2011 - 06:17 PM

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

#2 mip104


    V.I.P. Member

  • Veterans
  • PipPipPipPipPip
  • 4046 posts
  • 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
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

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users