Automatic refresh of spreadsheet

JimmyB · Apr 19th, 2002, 10:22 AM

Is there a way to have a spreadsheet automatically refresh or update?

Mark W. · Apr 19th, 2002, 10:25 AM

If you mean Calculate. Have a look at the Tools | Options... menu command's Calculation tab.

JimmyB · Apr 19th, 2002, 11:08 AM

No ... sorry not the calculate option. That occurs only on a cell value change and what I was looking for was to update a date automatcally .... like a real time clock. The spreadsheet goes out and grabs data on a date change and I don't want to be here every day to update it. Please help me go on vacation!

KniteMare · Apr 19th, 2002, 12:08 PM

the formula
=TODAY()
placed in a cell will return today's date.
Are you looking to do that?

Yours in EXCELent Frustration
KniteMare

JimmyB · Apr 22nd, 2002, 10:40 AM

I use the formula TODAY() in the calculation but the problem is that unless the spreadsheet is opened or the filed refreshed the date stays the same. I don't know how to automate the refreshing of the date field.

I would like to leave the sheet just sit there, go to the next day, update the day and go and get the new data ... without me touching a thing.

Hope someone can help ....

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

Apr 19th, 2002, 10:22 AM	#1
JimmyB New Member Join Date: Apr 2002 Posts: 5	Is there a way to have a spreadsheet automatically refresh or update?

Apr 19th, 2002, 10:25 AM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	If you mean Calculate. Have a look at the Tools \| Options... menu command's Calculation tab.

Apr 19th, 2002, 11:08 AM	#3
JimmyB New Member Join Date: Apr 2002 Posts: 5	No ... sorry not the calculate option. That occurs only on a cell value change and what I was looking for was to update a date automatcally .... like a real time clock. The spreadsheet goes out and grabs data on a date change and I don't want to be here every day to update it. Please help me go on vacation!

Apr 19th, 2002, 12:08 PM	#4
KniteMare Board Regular Join Date: Mar 2002 Location: Hilo, Hawaii Posts: 240	the formula =TODAY() placed in a cell will return today's date. Are you looking to do that? Yours in EXCELent Frustration KniteMare

Apr 22nd, 2002, 10:40 AM	#5
JimmyB New Member Join Date: Apr 2002 Posts: 5	I use the formula TODAY() in the calculation but the problem is that unless the spreadsheet is opened or the filed refreshed the date stays the same. I don't know how to automate the refreshing of the date field. I would like to leave the sheet just sit there, go to the next day, update the day and go and get the new data ... without me touching a thing. Hope someone can help ....