cell function will not recalculate

  • Thread starter Thread starter Alexandre
  • Start date Start date
A

Alexandre

Hey guys,
i have a pivot table that i am resizing through vba and then i am
refreshing a graph through vbs, then through normal excel functions i
am using an offset to take the grand total from the pivot table and
have it show in an other cell

i tryed to reset the cell functions
i tryed to force ir to recalculate using the .calculate

i still have not found a way for it to update properly other
then pressing twice on my button... (doing the operation twice)

can some one shed some light ?
Alex
 
Hey guys,
i have a pivot table that i am resizing through vba and then i am
refreshing a graph through vbs, then through normal excel functions i
am using an offset to take the grand total from the pivot table and
have it show in an other cell

i tryed to reset the cell functions
i tryed to force ir to recalculate using the .calculate

i still have not found a way for it to update properly other
then pressing twice on my button... (doing the operation twice)
Click to expand...


Did you set to Automatic the calculation?

Menu Tools, Option, Tab Calculation, press the radio button Automatic.


--
Hoping to be helpful...

Regards

Franz Verga
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA For excel 0
Protecting certain cells against volatile recalculation 1
Automatic recalculation of array functions 5
Pivot table report invalid 0
recalculation not recalculating some cells containing user functio 2
Excel Will Not Recalculate 2
Excel in Office 2007 does not do an automatic recalculate 6
Pivot Table Help! 1

Back
Top