PC Review Forums Newsgroups Microsoft Excel Microsoft Excel Crashes To copy and paste a formula or drag a formula now only pastes the.

Reply

To copy and paste a formula or drag a formula now only pastes the.
 
Thread Tools Rate Thread
Old 29-10-2004, 05:22 PM   #1
=?Utf-8?B?bm9yYWRvcmE=?=
Guest
 
Posts: n/a
Default To copy and paste a formula or drag a formula now only pastes the.


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 With Quote
Old 30-10-2004, 10:22 AM   #2
Nick Hodge
Guest
 
Posts: n/a
Default Re: To copy and paste a formula or drag a formula now only pastes the.
How is calculation set? Tools>options>calculation

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


"noradora" <noradora@discussions.microsoft.com> wrote in message
news:932E99EA-8B67-4BD5-809B-C4ABEEA7E4CF@microsoft.com...
> 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 With Quote
Reply

Archive


Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off