Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Continuous Refresh
I would like to continuously refresh a spreadsheet (as if I was holding down
the F9 key). Can anyone help? Doug |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Continuous Refresh
Usually clicking Tools, Options, Calculations, Automatic recalculates whe workbook every time a change is made. Do you need something else? -- raypayette ------------------------------------------------------------------------ raypayette's Profile: http://www.excelforum.com/member.php...o&userid=29569 View this thread: http://www.excelforum.com/showthread...hreadid=566221 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Continuous Refresh
Ray,
I would like it to refresh constantly. I am trying to build a "countdown clock" so that is shows me the date and time of an event and then the days, hours, minutes and seconds until that event happens. For example: A1: August 15, 2006 9:00 AM A2: =(A1-NOW())*24 ---- this would show me hours remaining A3: =A2*60 --------- this would show me minutes remaining etc, etc. When it refreshes constantly, it will show me a countdown. Doug "raypayette" wrote: Usually clicking Tools, Options, Calculations, Automatic recalculates whe workbook every time a change is made. Do you need something else? -- raypayette ------------------------------------------------------------------------ raypayette's Profile: http://www.excelforum.com/member.php...o&userid=29569 View this thread: http://www.excelforum.com/showthread...hreadid=566221 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Continuous Refresh
C Pearson designed an analog clock that ticks every second at: http://www.cpearson.com/excel/download.htm -- raypayette ------------------------------------------------------------------------ raypayette's Profile: http://www.excelforum.com/member.php...o&userid=29569 View this thread: http://www.excelforum.com/showthread...hreadid=566221 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Continuous Refresh
raypayette Wrote: Usually clicking Tools, Options, Calculations, Automatic recalculates whe workbook every time a change is made. Do you need something else?Hi raypayette, Here is some clock stuff, you may find something to help. http://www.andypope.info/fun/clocks.htm http://xcelfiles.homestead.com/VBA_Clock.html http://www.tushar-mehta.com/excel/so...ital_clock.htm http://j-walk.com/ss/excel/files/clockchart.htm http://kenmzoka.com/20001010CountdownClock.xls -- Desert Piranha ------------------------------------------------------------------------ Desert Piranha's Profile: http://www.excelforum.com/member.php...o&userid=28934 View this thread: http://www.excelforum.com/showthread...hreadid=566221 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Continuous Refresh
Ray and Desert Piranha,
Thanks for the links. But, those clock tools don't help me with refreshing the page. Is there a short piece of VBA code I can write to constantly refresh the calcs? Doug "Desert Piranha" wrote: raypayette Wrote: Usually clicking Tools, Options, Calculations, Automatic recalculates whe workbook every time a change is made. Do you need something else?Hi raypayette, Here is some clock stuff, you may find something to help. http://www.andypope.info/fun/clocks.htm http://xcelfiles.homestead.com/VBA_Clock.html http://www.tushar-mehta.com/excel/so...ital_clock.htm http://j-walk.com/ss/excel/files/clockchart.htm http://kenmzoka.com/20001010CountdownClock.xls -- Desert Piranha ------------------------------------------------------------------------ Desert Piranha's Profile: http://www.excelforum.com/member.php...o&userid=28934 View this thread: http://www.excelforum.com/showthread...hreadid=566221 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Continuous Refresh
Huber57 Wrote: Ray and Desert Piranha, Thanks for the links. But, those clock tools don't help me with refreshing the page. Is there a short piece of VBA code I can write to constantly refresh the calcs? DougHi Huber57, Maybe you could use something like this in a loop. Application.Calculate or ActiveSheet.Calculate -- Desert Piranha ------------------------------------------------------------------------ Desert Piranha's Profile: http://www.excelforum.com/member.php...o&userid=28934 View this thread: http://www.excelforum.com/showthread...hreadid=566221 |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Continuous Refresh
Perhaps this reference to volatile UDF's is what you need? http://blogs.officezealot.com/whitec...1/29/4005.aspx -- raypayette ------------------------------------------------------------------------ raypayette's Profile: http://www.excelforum.com/member.php...o&userid=29569 View this thread: http://www.excelforum.com/showthread...hreadid=566221 |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Continuous Refresh
Mr. Piranha,
Can you help me with a continuous loop VBA script? I don't know how any of that stuff works. Doug "Desert Piranha" wrote: Huber57 Wrote: Ray and Desert Piranha, Thanks for the links. But, those clock tools don't help me with refreshing the page. Is there a short piece of VBA code I can write to constantly refresh the calcs? DougHi Huber57, Maybe you could use something like this in a loop. Application.Calculate or ActiveSheet.Calculate -- Desert Piranha ------------------------------------------------------------------------ Desert Piranha's Profile: http://www.excelforum.com/member.php...o&userid=28934 View this thread: http://www.excelforum.com/showthread...hreadid=566221 |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
Continuous Refresh
If you don't know how a continuous loop works, you should study this and obtain general programming knowledge before asking help from this forum! -- raypayette ------------------------------------------------------------------------ raypayette's Profile: http://www.excelforum.com/member.php...o&userid=29569 View this thread: http://www.excelforum.com/showthread...hreadid=566221 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2k Pivot Table refresh scenario | Excel Discussion (Misc queries) | |||
External Data Refresh on save problem | Excel Discussion (Misc queries) | |||
How to refresh dropdown lists in PivotTables? | Excel Discussion (Misc queries) | |||
Query parameter "refresh when value changes" doesn't refresh - why | Excel Discussion (Misc queries) | |||
Refresh Imported Data - Does the Excel file have to be open? | Excel Discussion (Misc queries) |