Automatic refresh of linked cells in a workbook

S_Coupland

Board Regular
Joined
May 14, 2012
Messages
64
Hi All,

This may be a relativly simple one ( I Hope ).

I have a spreadsheet with a master sheet called Data Entry that contains all the data, from this data various other sheets in the workbook are populated using the formula ='Data Entry'!G354

Sometimes when people make changes to the Data Entry sheet they forget to refresh the connections, hence the updates does not appear anywhere on the linked sheets.

Is there a way to automate the Refresh All ( Ctrl+Alt+F5 ) function to run with a popup msg box warning of the updates when the spreadsheet is closed?

Many Thanks
 

Some videos you may like

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
There aren't any connections when formulas reference worksheets in the same workbook. All that's needed is calculate (F9). You could put Application.Calculate in the Workbook_BeforeClose event procedure.
 

Watch MrExcel Video

Forum statistics

Threads
1,109,549
Messages
5,529,468
Members
409,883
Latest member
asharris90
Top