Maybe...December 22 2011 at 3:24 AM
No score for this post
|Alan Hutchins |
from IP address 188.8.131.52
Response to Tracking spreadsheet retrievals
First off I have never used ASO, so my apologies if this does not help you.
If it were BSO, then I would write 2 macros :
Macro 1 - set all settings to standard, but set Navigate without data to on.
Macro 2 - revert all settings to standard
2 retrieve sheets:
Retrieve 2 - just top level dimensions only.
Ask users to run Macro 1, and then do one of their normal retrieves in sheet Retrieve 1, and disconnect. Then ask them to run Macro 2 and retrieve sheet "Retrieve2", and disconnect. Then send the workbook to you for evaluation.
That way you can see what they are looking at without the confidential data and Retrieve 2 should be just meaningless numbers.
I would also send out a note stating that you are asking for their assistance in determining whar gets used, as you want to review the performance of the system.
You never know, they might co-operate.
- Maybe - Fay on Dec 22, 2011, 12:39 PM