Results 1 to 2 of 2

Thread: New Sheet

  1. #1
    Join Date
    Dec 2002
    Phoenix, AZ

    Unanswered: New Sheet

    I created a macro that creates a new sheet in my workbook. It copies a sheet that has formulas already on it. The problem is- after the new sheet is created the formulas don't work. Everything gets copied like it is suppose to but the forumals won't calculate. Does anyone know why this would happen? Do i need to add something to the code tyo refresh the sheet?!!!

  2. #2
    Join Date
    Oct 2003
    Howdy. Two questions.

    1. Has Calculation been set to Manual? Tools > Options > Calculation (tab). Click on Automatic.

    2. If the formulas are set to reference the same as the original worksheet, then there is no "re-calculation" unless you change the underlying data. Is that what you want? Or do you have difference references that need to be made?
    old, slow, and confused
    but at least I'm inconsistent!

    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts