Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2003
I recently discovered that Excel 2003 seems to invoke Functions when rows are hidden and unhidden. I have a rather large spreadsheet that I've used for years, and it has several custom functions and macros. The macros basically hide and unhide rows based on selections a user makes, and the functions are just basic stuff. I have proven that in Excel 2002, the functions are NOT called when rows are hidden or unhidden, but the same spreadhsheet opened in 2003 DOES call the functions when rows are hidden/unhidden. The result of this is it is VERY slow...Keep in mind, it is NOT the macro because even if you just highlight a bunch of rows, it is slow, BECAUSE it is calling the function. Does anyone know WHY it thinks the function needs to be called?
Thanks, Steve |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2003
Hi Steve,
I agree that Excel 2003 has changed the way it handles hiding/unhiding rows: hiding and unhiding (even when no rows are actually hidden or unhidden) seems to flag the rows as dirty, which triggers a recalculation if calculation is automatic. Previous versions of Excel did not do this. I do not know why it does this. You can bypass most of the problem by switching calculation to manual at the start of your macro, and back to automatic at athe end. regards Charles ______________________ Decision Models The Excel Calculation Site. www.DecisionModels.com "sclark" wrote in message ... I recently discovered that Excel 2003 seems to invoke Functions when rows are hidden and unhidden. I have a rather large spreadsheet that I've used for years, and it has several custom functions and macros. The macros basically hide and unhide rows based on selections a user makes, and the functions are just basic stuff. I have proven that in Excel 2002, the functions are NOT called when rows are hidden or unhidden, but the same spreadhsheet opened in 2003 DOES call the functions when rows are hidden/unhidden. The result of this is it is VERY slow...Keep in mind, it is NOT the macro because even if you just highlight a bunch of rows, it is slow, BECAUSE it is calling the function. Does anyone know WHY it thinks the function needs to be called? Thanks, Steve |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2003
I suspect the reason that Excel 2003 has to do this is because the SUBTOTAL
function has an option to ignore or include hidden rows, and therefore Excel needs to recalculate if you hide or unhide rows. regards Charles ______________________ Decision Models The Excel Calculation Site. www.DecisionModels.com "Charles Williams" wrote in message ... Hi Steve, I agree that Excel 2003 has changed the way it handles hiding/unhiding rows: hiding and unhiding (even when no rows are actually hidden or unhidden) seems to flag the rows as dirty, which triggers a recalculation if calculation is automatic. Previous versions of Excel did not do this. I do not know why it does this. You can bypass most of the problem by switching calculation to manual at the start of your macro, and back to automatic at athe end. regards Charles ______________________ Decision Models The Excel Calculation Site. www.DecisionModels.com "sclark" wrote in message ... I recently discovered that Excel 2003 seems to invoke Functions when rows are hidden and unhidden. I have a rather large spreadsheet that I've used for years, and it has several custom functions and macros. The macros basically hide and unhide rows based on selections a user makes, and the functions are just basic stuff. I have proven that in Excel 2002, the functions are NOT called when rows are hidden or unhidden, but the same spreadhsheet opened in 2003 DOES call the functions when rows are hidden/unhidden. The result of this is it is VERY slow...Keep in mind, it is NOT the macro because even if you just highlight a bunch of rows, it is slow, BECAUSE it is calling the function. Does anyone know WHY it thinks the function needs to be called? Thanks, Steve |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 versus Excel 2003 & Excel 97-2003 fully compatible | Excel Worksheet Functions | |||
importing/linking data from an Access 2003 Query to an Excel 2003 | Excel Discussion (Misc queries) | |||
import Excel 2003 file into Outlook 2003 - NO NAMED RANGES?? | Excel Discussion (Misc queries) | |||
Copying Excel 2003 Selection into Outlook 2003 HTML E-Mail Message | Excel Discussion (Misc queries) | |||
Excel 2003 Database Driver Visual FoxPro 7 on Server 2003. | Excel Discussion (Misc queries) |