PC Review


Reply
Thread Tools Rate Thread

Copy formulas not working

 
 
Dave Stitz
Guest
Posts: n/a
 
      25th Jun 2007
I am trying to copy simple formulas in a spreadsheet and Excel appears to
only be copying the values. But when I go to the cell, it has the correct
formula, but the wrong result. I have not seen this before...can anyone
help?? The formula I copy has the same result in ever cell but they are
wrong.

Frustrated.



 
Reply With Quote
 
 
 
 
David Biddulph
Guest
Posts: n/a
 
      25th Jun 2007
Tools/ Options/ Calculation:
se it to Automatic.
--
David Biddulph

"Dave Stitz" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I am trying to copy simple formulas in a spreadsheet and Excel appears to
>only be copying the values. But when I go to the cell, it has the correct
>formula, but the wrong result. I have not seen this before...can anyone
>help?? The formula I copy has the same result in ever cell but they are
>wrong.
>
> Frustrated.
>
>
>



 
Reply With Quote
Reply

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

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
automatically copy formulas down columns or copy formulas all the =?Utf-8?B?SG93bGluZ0JsdWU=?= Microsoft Excel Worksheet Functions 1 16th Mar 2007 11:11 PM
How do I copy formulas but using the same range each time I copy =?Utf-8?B?TGFmZmlu?= Microsoft Excel Worksheet Functions 2 22nd Jun 2006 04:17 PM
copy formulas from a contiguous range to a safe place and copy them back later Lucas Budlong Microsoft Excel Programming 2 22nd Feb 2006 08:26 PM
Range COPY function - how to copy VALUES and not formulas James Cooke Microsoft Excel Programming 1 21st Aug 2003 07:04 PM
Range COPY function - how to copy VALUES and not formulas James Cooke Microsoft Excel Worksheet Functions 1 21st Aug 2003 07:04 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:19 AM.