General information
Category:
COM/DCOM and OLE Automation
Looks like I misunderstood the recalc functions in Excel.
Shift-F9 recalcs only the active sheet and _only_ the cells that it thinks need recalcing (Ie. if a cell has a dependancy on another cell whose value has changed).
F9 alone recalcs the whole workbook using the same logic as Shift-f9.
Ctrl-Alt-F9 recalcs the entire sheet, cell by cell with no exclusions.
Since Excel wasn't aware that the logic in my Add-in server had changed, it saw no need to recalc the cells that used one of it's functions. Once I hit Ctrl-Alt-F9, I got the results I was looking for.
Problem solved.
Hope this helps someone.
-Matt
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only