Won't Autocalculate

[AlexSlivi]

I have an Excel file where the Summary sheet is already in place and so are the calculations within the Summary sheet. And then I have to import three sheets from another workbook and do a couple macros on them in order to format them properly, create pivot tables, etc. Once that is all in place I need the Summary tab to read from the pivot tables and perform the calculations written within it.

Autocalculate is on, I've tried changing the custom cell type to general or number and those don't work, I've hit every combination of F9 possible, I've hit Calculate sheet. The only way the calculations perform is one by one if you press enter or F2.

If you could help, I'd greatly appreciate it.

 

[TiaXL]

I have an Excel file where the Summary sheet is already in place and so are the calculations within the Summary sheet. And then I have to import three sheets from another workbook and do a couple macros on them in order to format them properly, create pivot tables, etc. Once that is all in place I need the Summary tab to read from the pivot tables and perform the calculations written within it.

Autocalculate is on, I've tried changing the custom cell type to general or number and those don't work, I've hit every combination of F9 possible, I've hit Calculate sheet. The only way the calculations perform is one by one if you press enter or F2.

If you could help, I'd greatly appreciate it.

try doing it in your code

Sheets("Summary").select
 
calculate

 

[AlexSlivi]

That didn't work either.

 

[TiaXL]

That didn't work either.

are you importing new data and creating pivot's or importing data and refreshing existing pivots ?

as you will obviously need to code the pivot to refresh

 

[SuperFerret]

Have you tried this?
http://www.mrexcel.com/forum/showpost.php?p=2764421&postcount=2

 

[AlexSlivi]

That worked. Thank you.