LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
DRK DRK is offline
external usenet poster
 
Posts: 40
Default Forcing recacalculation

I have a two workbooks which are linked together. One field in the master
workbook has a TRUE/FALSE field. Through a link to a similar field on the
slave workbook, it controls which set of values are being used. The values
are either Financed or NonFinanced.

When I run a macro to print either set of values, the macro sets the value
in the master to either TRUE or FALSE. Then it prints. The print always seems
to be one behind - that even though the valuie was set to TRUE by the macro,
the calculated values are for the FALSE setting. And vice-versa if the macro
sets it to false - it prints the TRUE version.

If you run it the second time - without resetting the TRUE/FALSE, it's fine.

I've tried applying Application.Volatile TRUE but it doesn't seeem to be
helping.

What else can I do to get the workbooks in synch?
--
DRK
 
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
Forcing to recalculate Michael.Tarnowski Excel Worksheet Functions 7 February 11th 09 02:49 PM
Forcing to Uppercase Connie Martin Excel Discussion (Misc queries) 4 February 7th 08 08:37 PM
forcing UDF to run Stefi Excel Worksheet Functions 4 December 29th 05 03:46 PM
Forcing an input in a pop up box David Excel Programming 2 October 5th 04 11:31 PM
Forcing users M atthew J. Couture Excel Programming 1 April 4th 04 05:25 PM


All times are GMT +1. The time now is 05:17 AM.

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

About Us

"It's about Microsoft Excel"