+ Reply to Thread
Results 1 to 4 of 4

Formulas autofill ok but continues to carry tot from 1st column??

  1. #1
    ET
    Guest

    Formulas autofill ok but continues to carry tot from 1st column??

    I have been using the Sum and Subtotal function on my spreadsheet for a year
    with no problem. All of a sudden when I change my formula to include
    additional lines or use the filter, the formulas are no longer working. It
    autofills correctly, but carries the total from the 1st column all the way
    across and does not change when I change the filters unless I click in the
    formula bar for each column.

  2. #2
    Guest

    Re: Formulas autofill ok but continues to carry tot from 1st column??

    Hi

    Make sure that your calculation is set to automatic. It's on
    Tools/Options/Calculation tab.

    Andy.

    "ET" <ET@discussions.microsoft.com> wrote in message
    news:E32A7D48-ED6E-4A9A-BA01-F0B5A565DBF5@microsoft.com...
    >I have been using the Sum and Subtotal function on my spreadsheet for a
    >year
    > with no problem. All of a sudden when I change my formula to include
    > additional lines or use the filter, the formulas are no longer working.
    > It
    > autofills correctly, but carries the total from the 1st column all the way
    > across and does not change when I change the filters unless I click in the
    > formula bar for each column.




  3. #3
    ET
    Guest

    Re: Formulas autofill ok but continues to carry tot from 1st colum

    Thank you very much, now I can be productive again. I have no idea why this
    would have changed.

    "Andy" wrote:

    > Hi
    >
    > Make sure that your calculation is set to automatic. It's on
    > Tools/Options/Calculation tab.
    >
    > Andy.
    >
    > "ET" <ET@discussions.microsoft.com> wrote in message
    > news:E32A7D48-ED6E-4A9A-BA01-F0B5A565DBF5@microsoft.com...
    > >I have been using the Sum and Subtotal function on my spreadsheet for a
    > >year
    > > with no problem. All of a sudden when I change my formula to include
    > > additional lines or use the filter, the formulas are no longer working.
    > > It
    > > autofills correctly, but carries the total from the 1st column all the way
    > > across and does not change when I change the filters unless I click in the
    > > formula bar for each column.

    >
    >
    >


  4. #4
    Guest

    Re: Formulas autofill ok but continues to carry tot from 1st colum

    Glad you're sorted!! This option is determined by the first sheet you open
    in any session - and it is Excel-wide. Therefore, the first sheet you opened
    today must have been saved with calculation set to manual.

    Andy.

    "ET" <ET@discussions.microsoft.com> wrote in message
    news:BD197A54-D3AE-4240-B85C-3EA5CC84E6E6@microsoft.com...
    > Thank you very much, now I can be productive again. I have no idea why
    > this
    > would have changed.
    >
    > "Andy" wrote:
    >
    >> Hi
    >>
    >> Make sure that your calculation is set to automatic. It's on
    >> Tools/Options/Calculation tab.
    >>
    >> Andy.
    >>
    >> "ET" <ET@discussions.microsoft.com> wrote in message
    >> news:E32A7D48-ED6E-4A9A-BA01-F0B5A565DBF5@microsoft.com...
    >> >I have been using the Sum and Subtotal function on my spreadsheet for a
    >> >year
    >> > with no problem. All of a sudden when I change my formula to include
    >> > additional lines or use the filter, the formulas are no longer working.
    >> > It
    >> > autofills correctly, but carries the total from the 1st column all the
    >> > way
    >> > across and does not change when I change the filters unless I click in
    >> > the
    >> > formula bar for each column.

    >>
    >>
    >>




+ 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