copy worksheet ... formulas do not update

G

Guest

I am coping a worksheet (in the same workbook) and then renaming the sheet
all in vba code. There are formulas on the source sheet, and copied sheet,
that point to a third sheet. The problem is that my formulas do not update
when I change data on a third sheet.

I tried coping the sheet then reentering the formula, in VBA, but that does
not work either.

Note that application calculation is turn to automatic

Any thoughts?

Thanks in advance,

Stewart
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy Worksheet Formula Problem 3
E2007 formulas display as formulas, not results 3
copied formulas refer to destination sheet not source sheet 2
Dependent drop down dynamic range formula, off sheet. 7
Formulas do not update 2
insert blank row and formulas 1
Auto Update worksheet references as new worksheets are added 1
Copying Excel Cells including Names Into Existing Spreadsheet 3

Top