Posted to microsoft.public.excel.programming

SS[_2_]

external usenet poster

Posts: 12

how to refresh entire sheet?

I've got data that displays a value cells by calling that cell

so my cell, for example a1, has =b6

in b6 i have a number.

If i do F2 on the cell the cell updates and shows that number
how can I refresh all the other cells, in one go, in the series so that they
show the numbers that correspond to them?

SS

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Refresh all but 1st sheet	pgarcia	Charts and Charting in Excel	2	September 9th 08 02:39 PM
refresh sheet data	Dragos	Excel Discussion (Misc queries)	0	July 11th 07 09:12 AM
Refresh Pivot in Locked Sheet?	Dark_Templar	Excel Discussion (Misc queries)	1	June 5th 06 06:37 PM
Copy the entire sheet to overlay existing sheet?	LurfysMa	New Users to Excel	2	August 29th 05 07:05 PM
Forced Refresh on a Linked Sheet	Heidi Harting-Rex	Excel Programming	0	September 18th 03 10:11 PM

All times are GMT +1. The time now is 02:04 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us