VBA Refresh won't refresh anymore

[rjacmuto32]

I have a pivot table and i recorded a macro to update it.


SImple code of

ActiveSheet.PivotTables("PivotTable4").PivotCache.Refresh


And after several days of testing and running that little code, now it wants to debug and gives me a error. The pivot table hasn't moved and is still named that.


I also created a new tab and a new pivot table with a same code just named it PivotTabTest and same thing. None of my macro refresh code is working. Anyone seen this before

 

[SirJB7]

Hi, rjacmuto32!


Maybe this helps you:

http://chandoo.org/forums/topic/pivottable-refresh-issue

http://chandoo.org/forums/topic/auto-update-a-pivot-table

http://chandoo.org/forums/topic/marco-to-refresh-a-pivot-table-very-very-urg


Regards!

 

[rjacmuto32]

None of those helped. Wonder if it has anything to do with me refreshing the same pivot table about 1,000 times. I went to do it manually and the refresh button won't refresh the data manually. It says the pivot table name is invalid. I went to change the source data and still said name was invalid.


I created a new table on new tab, same thing. Unable to update any of my pivots (all referencing data in teh same file.

 

[Hui]

Rjacmuto32


Save the file

Close Excel

Reopen excel and open the file

Ctrl Alt F9

Save the file

Close the file

Reopen the file


Has that helped ?


Have you tried Open & Repair ?


Also


Does your file have any :


Circular reference errors?

Or any Data Table functions?

 

[rjacmuto32]

That didn't work either with the save, close, alt9, etc.


I checked for circular references, none are there. There are also no data table functions.


Weird. I'm going to redo file and see if it happens again. First time I have ever seen this in excel.

 

[SirJB7]

Hi, rjacmuto32!

Considered uploading the file?

Regards!