Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Refreshing fields in Excel
I have fields that get updated on a shared document on a server for multiple
users within the company. If a data point is changed (entered manually) the others have to refresh each time and this is in the neighborhood of 100 users. Is there a way to run something along the lines of a macro to auto-update the document for each user without the users (who are not entering data but using it) having to hit refresh each time |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Refreshing fields in Excel
Assuming that the workbook is a shared workbook, you can set updates to
update every x number of minutes. Click TOOLS in the menu, select SHARE WORKBOOK, click the ADVANCED tab and in the middle of the tab page click the AUTOMATICALLY EVERY option button and set the refresh rate. Minimum value for refreshing the workbook is 5 minutes. -- Kevin Backmann "Greg Hoover" wrote: I have fields that get updated on a shared document on a server for multiple users within the company. If a data point is changed (entered manually) the others have to refresh each time and this is in the neighborhood of 100 users. Is there a way to run something along the lines of a macro to auto-update the document for each user without the users (who are not entering data but using it) having to hit refresh each time |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Refreshing an Excel Query | Excel Discussion (Misc queries) | |||
Excel SHOULD NOT AUTO-CHANGE formated text fields to DATE FIELDS! | Excel Worksheet Functions | |||
Problems refreshing internal queries in excel | Excel Discussion (Misc queries) | |||
Refreshing Data In Excel / VBA | Excel Discussion (Misc queries) | |||
Refreshing Access data in Excel | Excel Discussion (Misc queries) |