Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...
MS Office Forum / Excel / Excel Errors / October 2004

Tip: Looking for answers? Try searching our database.

To copy and paste a formula or drag a formula now only pastes the.

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
noradora - 29 Oct 2004 17:22 GMT
All of a sudden when I drag a formula, or copy and paste a formula, only the
value of the first cell is displayed, although the formula shows in the new
cells.  I have to actually click on F2 to activate the formula and have it
calculate the appropriate values.
Reply to this Message
Nick Hodge - 30 Oct 2004 10:22 GMT
How is calculation set? Tools>options>calculation

Signature

HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS

> All of a sudden when I drag a formula, or copy and paste a formula, only
> the
> value of the first cell is displayed, although the formula shows in the
> new
> cells.  I have to actually click on F2 to activate the formula and have it
> calculate the appropriate values.
Reply to this Message
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage
Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.