Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old October 27th 04, 06:37 PM
Datasort
 
Posts: n/a
Default copy worksheet ... formulas do not update

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


  #2   Report Post  
Old October 27th 04, 07:01 PM
Frank Kabel
 
Posts: n/a
Default

Hi
post an example of your formulas

--
Regards
Frank Kabel
Frankfurt, Germany


Datasort wrote:
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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy answer to another worksheet mjohnson0321 Excel Discussion (Misc queries) 3 January 22nd 05 01:11 PM
how do i copy vertical formulas to horizonal and keep same cell r. opiedrake Excel Discussion (Misc queries) 3 January 12th 05 05:18 PM
Way to make Excel only run certain formulas on a worksheet? jrusso Excel Discussion (Misc queries) 0 January 12th 05 04:23 PM
how do I make a copy of a worksheet and retain formulas but not data FireBrick Setting up and Configuration of Excel 2 December 29th 04 07:33 PM
How do I copy page setup from one worksheet & paste into new shee. Rasc0 Excel Discussion (Misc queries) 2 December 1st 04 10:12 PM


All times are GMT +1. The time now is 06:30 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017