+ Reply to Thread
Results 1 to 3 of 3

Formula correct, answer wrong

  1. #1
    TJAC
    Guest

    Formula correct, answer wrong

    I have a spreadsheet that when I copy the formula, it copies correctly
    (changes the cells it should subtract), however, the result stays the same.
    It matches the formula I copied it from, even though the cells to calculate
    are now different. I even did a paste special and said only formula, but
    still, same result. If I actually type in the formula, it works fine, but I
    have a lot I need to copy and paste. Is there a way I can fix this?

    Thanks,

  2. #2
    Forum Contributor
    Join Date
    11-29-2005
    Posts
    142
    Perhaps you have calculations set to Manual.

    Press F9 to confirm. Calculations should now work.


    To set to automatic calcs:

    Go to Tools|Options and in the Calculation Tab, set Calculation to Automatic.

    Click Ok.

  3. #3
    Bob Phillips
    Guest

    Re: Formula correct, answer wrong

    It sounds as though you have manual calculation set.

    Go to Tools>Options>Calculation, and click the Automatic button.

    --

    HTH

    RP
    (remove nothere from the email address if mailing direct)


    "TJAC" <TJAC@discussions.microsoft.com> wrote in message
    news:BD9FABC9-A591-4BBE-B05F-FA31B1C66400@microsoft.com...
    > I have a spreadsheet that when I copy the formula, it copies correctly
    > (changes the cells it should subtract), however, the result stays the

    same.
    > It matches the formula I copied it from, even though the cells to

    calculate
    > are now different. I even did a paste special and said only formula, but
    > still, same result. If I actually type in the formula, it works fine, but

    I
    > have a lot I need to copy and paste. Is there a way I can fix this?
    >
    > Thanks,




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1