Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
Query results update problem (Read 1911 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Query results update problem
20.04.09 at 16:32:24
 
Query results update problem
 
Quote:

I have an excel sheet which contains 2 different Tabs with different data's
(Defects) & (Bubbles). See attached screen shot. All Queries are stored in an
extra Tab called 'Queries'.

 

 
Quote:

When I execute a 'force calculation of all functions' only the Tab gets
updated in which I started the calculation. When I switch to the second
tab I need to rerun the force calculation.

Any idea?


 
Answer:
The calculation of functions feature will recalculate all functions in the current sheet. So functions in other sheets will not be recalculated.
 
You should be able to record a macro to do this quite easily.
Start the macro recorder. Select the sheet  you want to recalculate, calculate the sheet and then select the next sheet on which you do the same. When you are finished, stop the macro recorder.  
When you rerun the macro it should do again precisely what you did when you recorded the macro. The function call recorded should be:
SQLXL.mnuCalculateAllFunctions_Click
Back to top
 
« Last Edit: 20.04.09 at 16:36:24 by Gerrit-Jan Linker »  

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1