Posted to microsoft.public.excel.programming

Resant

external usenet poster

Posts: 23

Problem:Query Cell contain Formula from QueryTable is always get old value

It seem that I must force a workbook to calculate the formula.
Is it possible to calculate a closed workbook?

Please help me...

Thanks,

Resant

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Problem Maintaining Cell Format After Query	Mike	Excel Worksheet Functions	0	August 14th 08 03:36 AM
Populate QueryTable Using SQL Server - Connection Problem	AMIT	Excel Programming	1	September 7th 05 09:34 AM
Excel Web Query using a QueryTable via HTTPS??	Bing	Excel Programming	2	April 2nd 05 03:51 PM
Selection.QueryTable problem	JenC	Excel Programming	2	January 7th 05 05:32 AM
MS QUERY w/out querytable	No Name	Excel Programming	1	October 24th 03 03:55 PM

All times are GMT +1. The time now is 04:22 PM.

About Us

"It's about Microsoft Excel"