Refreshing Formulas

mindhacker · Feb 27th, 2002, 03:38 PM

I export data to Excel and then copy that data to another spreadsheet. Various formulas and graphs are referencing that data. When I put new data in, the formula cells and graphs don't refresh automatically. If I open a cell and save it refreshes. Anybody know of a way to get it to refresh automatically?

anno · Feb 27th, 2002, 04:17 PM

have you tried the excel help topic "Refresh external data"? i think this bit is what you are after:
" You can refresh an external data range automatically when you open the workbook, and optionally save the workbook without saving the external data, so that the workbook file size is reduced. On the External Data toolbar, click Data Range Properties ,
and then select the Refresh data on file open check box. To save the workbook with the query definition but without the external data, select the Remove external data from worksheet before saving check box."

mindhacker · Feb 27th, 2002, 04:36 PM

I just found it. Tools > Options > Calculation > Automatic

Jack in the UK · Feb 27th, 2002, 04:36 PM

Ho

Use the button refresh external data thats ODBC links and will rip new good live data as a posed to odd bad data, live data is always best if poss before i get shot again, bad dat i class as out of date - but thats job specific, with me seconds count in finance world so always refresh and data hungry.

I prefer to avoid auto updates as i like to command when i want data = so i refesh when i want, even calculation is manual so i havethe power to get as i want, worthy point the bigger the sheets more data and caculations the worst it gets.

HTH

Feb 27th, 2002, 04:36 PM	#4
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,064	Ho Use the button refresh external data thats ODBC links and will rip new good live data as a posed to odd bad data, live data is always best if poss before i get shot again, bad dat i class as out of date - but thats job specific, with me seconds count in finance world so always refresh and data hungry. I prefer to avoid auto updates as i like to command when i want data = so i refesh when i want, even calculation is manual so i havethe power to get as i want, worthy point the bigger the sheets more data and caculations the worst it gets. HTH __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 27th, 2002, 03:38 PM	#1
mindhacker New Member Join Date: Feb 2002 Posts: 3	I export data to Excel and then copy that data to another spreadsheet. Various formulas and graphs are referencing that data. When I put new data in, the formula cells and graphs don't refresh automatically. If I open a cell and save it refreshes. Anybody know of a way to get it to refresh automatically?

Feb 27th, 2002, 04:17 PM	#2
anno Board Regular Join Date: Feb 2002 Posts: 202	have you tried the excel help topic "Refresh external data"? i think this bit is what you are after: " You can refresh an external data range automatically when you open the workbook, and optionally save the workbook without saving the external data, so that the workbook file size is reduced. On the External Data toolbar, click Data Range Properties , and then select the Refresh data on file open check box. To save the workbook with the query definition but without the external data, select the Remove external data from worksheet before saving check box."