+ Reply to Thread
Results 1 to 8 of 8

calculate before save

  1. #1
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Poland
    MS-Off Ver
    Excel 2016-365
    Posts
    2,940

    calculate before save

    Hi,

    i am not exactly understand how this method is working.

    I added:

    Please Login or Register  to view this content.
    When User is exiting workook he gets question about saving changes (Do you want to save changes? Yes, no, Cancel).
    I want to calculate whole workbook if user will save.

    How to do this?
    Jacek
    Last edited by jaryszek; 06-06-2019 at 10:34 AM.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: calculate before save

    WB will automatically save (with the option to save/not save) when it is closed. You would just need to code to Save
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Poland
    MS-Off Ver
    Excel 2016-365
    Posts
    2,940

    Re: calculate before save

    Ok but the problem is when you opening and have excel in enabled macros state. Until you will click this the calculation is not performed.
    This is why i have to calculate before save.

    The code provided above will work?

    Jacek

  4. #4
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Poland
    MS-Off Ver
    Excel 2016-365
    Posts
    2,940

    Re: calculate before save

    Can anybody confirm the code above?

  5. #5
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Poland
    MS-Off Ver
    Excel 2016-365
    Posts
    2,940

    Re: calculate before save

    Hi,

    bump,

    Best Wishes,
    Jacek

  6. #6
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Poland
    MS-Off Ver
    Excel 2016-365
    Posts
    2,940

    Re: calculate before save

    Nobody is using it?

    Jacek

  7. #7
    Registered User
    Join Date
    08-19-2013
    Location
    Philippines
    MS-Off Ver
    Excel 2007
    Posts
    11

    Re: calculate before save

    If your Calculation Options is already in Manual, then you can add only the Application.Calculation = xlCalculationAutomatic when you close it. But if it's already in Automatic, then you won't need any codes for this.

  8. #8
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Poland
    MS-Off Ver
    Excel 2016-365
    Posts
    2,940

    Re: calculate before save

    thank you.

    Jacek

+ 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. Replies: 1
    Last Post: 04-29-2016, 11:55 AM
  2. Macro to calculate formula automatically from a list of input and save each result
    By Alex Zana in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-07-2016, 07:07 AM
  3. Calculate daily hours but save as monthly and yearly hours each day
    By auzgts in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 06-17-2014, 06:14 AM
  4. Save calculated results in cells not thge formulas used to calculate them
    By maineiac4ever in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-29-2012, 12:31 AM
  5. [SOLVED] save multiple "calculate now" scenarios to a log
    By jrtaylor in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-09-2012, 06:12 PM
  6. Excel Auto Calculate and Save to new row
    By mbuckley56 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-23-2012, 02:52 PM
  7. [SOLVED] Formulas don't calculate until SAVE (excel 2000)
    By Rick G. in forum Excel General
    Replies: 2
    Last Post: 05-19-2005, 01:06 PM

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