+ Reply to Thread
Results 1 to 1 of 1

Sheets/Workbook Not Calculating after Macro run

  1. #1
    Forum Contributor
    Join Date
    05-27-2012
    Location
    New Brunswick, Canada
    MS-Off Ver
    Excel 2016
    Posts
    276

    Sheets/Workbook Not Calculating after Macro run

    So Sheets 2 through 19 have pasted data from an external source, which I then created a Summary sheet for with references to the cells I want to show data from.
    I then created an English and French tab because my first paste into Sheets 2 through 19 is with English data, then I paste again with French data (both from external sources).
    On both the English & French tabs, the data for the last 2 weeks needs to be updated so I need to pull data from Row 21 on the Summary tab into certain cells in Column H and I respectively. For instance Summary!D21 needs to be entered into English!H3, Summary!D22 into English!H4, etc etc. You can see Macro "EngAbsV2" for what goes where. I also created macro "FrAbsV2" because I need to do the exact same steps on the French sheet.

    My problem is that when I run "EngAbsV2", the formulas gets entered but nothing shows up because the sheet/workbook doesn't want to recalculate. So when I go back and look at the Summary sheet, it also shows blanks, seemingly "Uncalculating" itself.

    I've also tried creating a macro where a cell value from English equals the cell value from Summary but it also shows up blank until I hit F9 because Summary shows blanks even though 2 minutes ago I saw data. Ideally this is the best solution because I don't want it referencing the formula, I want it referencing the value that is there at the moment. That value will then change once I go from English data to French data and I don't want English and French referencing the same data.

    I've even gone to the macro recorder and recorded pressing F9 yet that doesn't work either. It only works if I physically press F9 or press the Calculate Now button on Excel.

    Does anyone have any solutions?
    Attached Files Attached Files

+ 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: 09-24-2016, 08:05 AM
  2. [SOLVED] Macro to copy sheets from workbook and create new workbook
    By sudric in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-18-2015, 11:53 AM
  3. Calculating across multiple sheets/tabs in the same workbook
    By cgsweger in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-17-2014, 04:26 PM
  4. [SOLVED] Macro to copy cells from multiple sheets in workbook to multiple sheets in other workbook
    By KeithMale in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-13-2013, 05:37 PM
  5. [SOLVED] copy all sheets from one workbook to the workbook running the macro
    By synergio in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 12-28-2012, 06:20 AM
  6. Extracting Data from 2 sheets & Placing in other 2 sheets of same workbook using VBA Macro
    By ukash.dost@gmail.com in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-10-2012, 08:56 AM
  7. Macro for filter on protected workbook that works for all sheets, no matter what sheets are named?
    By StargateFanFromWork in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-26-2006, 02:35 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