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

I have 2 workbooks, workbook A and workbook B. Everytime
workbook A is opened it references cells in workbook B. I
want to know if there is a way I can track the number of
times workbook B is queried. For instance, here is a
formula that is in cell A1 of workbook A. If I were to
open that workbook 2 times, it would query cell A1 in
workbook B 2 times. I want to keep track of this. How
can I do this?

='Q:\QTD\Current Version\[FULLY DYNAMIC REVISION.xls]Quick
Reference'!A1

 
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
Counter Mubarak Excel Discussion (Misc queries) 1 December 21st 09 05:34 PM
Add A Day Counter EisPanzer Excel Discussion (Misc queries) 3 May 9th 07 01:24 AM
Counter Sdbenn90 Excel Discussion (Misc queries) 4 January 9th 06 11:43 AM
Linked worksheet Query Counter Ed Lisay Excel Programming 1 September 14th 03 08:43 PM
Counter Larry Hau Excel Programming 1 August 14th 03 11:00 PM


All times are GMT +1. The time now is 11:00 AM.

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

About Us

"It's about Microsoft Excel"