+ Reply to Thread
Results 1 to 2 of 2

Cells Not Updating

Hybrid View

chcwebb Cells Not Updating 06-23-2009, 11:24 AM
royUK Re: Cells Not Updating 06-23-2009, 11:29 AM
  1. #1
    Registered User
    Join Date
    06-18-2009
    Location
    America
    MS-Off Ver
    Excel 2003
    Posts
    8

    Cells Not Updating

    I have made a macro that takes a worksheet of data and turns it into several summaries of that data. The macro works fine, but if any values are changed after the macro finishes, formulas that reference them will not automatically update, even if they are simple sums. I have to manually select each formula and press enter to update its values. Does anyone know why this might be happening?

    One possible reason for this is that some variables early on in the string of equations reference values in another spreadsheet. I know that formulas which reference values in another spreadsheet will not normally update automatically, so maybe cells that reference those cells, or cells that reference cells that reference those cells, etc., from autoupdating.

    I am posting this problem in the programming forum because I am almost certain that this is because of a macro, since only macros edit the document itself.

    If anyone has encountered this problem before and knows how it might be fixed, please tell me.

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Cells Not Updating

    Does your code turn automatic calculation off, without switching it back on?
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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