+ Reply to Thread
Results 1 to 2 of 2

Cost sheet data only totals/aggregates once I press save

  1. #1
    Registered User
    Join Date
    08-17-2016
    Location
    Silver Spring, Maryland USA
    MS-Off Ver
    Microsoft Office 365 2016
    Posts
    1

    Cost sheet data only totals/aggregates once I press save

    I have a plethora of spreadsheets for my business that are all copies of the same template. All of them are based on the same formulas and are exact copies. Some spreadsheets work properly and some of them do not. The problem I am having is that when I enter numbers in their cells, the final costs are not totaled until I press save on the spreadsheet. It should total as soon as I finish entering the data.

  2. #2
    Valued Forum Contributor Neil_'s Avatar
    Join Date
    04-19-2013
    Location
    Yorkshire
    MS-Off Ver
    Office 365 Enterprise E3 2013 / 2016
    Posts
    479

    Re: Cost sheet data only totals/aggregates once I press save

    Does hitting F9 recalculate? If so, the spreadsheet has had it's options changed from automatic calculation to manual calculation. This is set in File>Options>Formulas
    Frob first, tweak later

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Press Save - Hide Sheets (before saving) - Actually Save - Unhide Sheets Again
    By MixedupExcel in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-28-2015, 07:22 AM
  2. How do I make a master cost sheet talk to all of my existing cost sheets?
    By JeremyGreiner in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-24-2013, 09:50 PM
  3. Calculating sub-totals for different cost centres
    By nick carntowan in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-25-2011, 06:55 AM
  4. Replies: 17
    Last Post: 05-19-2009, 11:34 AM
  5. Having to Press F2 to recognise data from another sheet in Excel
    By ajbutler in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-26-2007, 07:43 AM
  6. I need to input daily cost codes would exceli calculate my totals
    By davisbc in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-06-2005, 03:05 PM
  7. Using a sperate sheet to save daily revenue totals
    By justchris in forum Excel General
    Replies: 1
    Last Post: 03-09-2005, 01:49 AM

Tags for this Thread

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