I have developed a code for work, and I created a loop to update formulas in certain cells. I only call this loop if the cells are misalligned from the most resent data update. When it runs the loop takes about a minute or more to run, depending on the spreadsheet, and the whole workbook takes about 10 minutes. I was hoping someone knew a way to reduce the run time. I will not be the only one using it, and while calculating it makes excel inoperable. Either by created a better looping system, or ways to exclude values from blank pivot tables.

One key note is that in the first few columns, I have to have the value blank due to a calculation in the sheet.

The spreadsheet is pulling data from a pivot table in a different workbook. Is there a way to tell it not to import a value if the cell is blank in the pivot table. Right now I have it importing the cell, then checking the value, and replacing it with a null if that is the case.

Thanks in advance for help!!!

Mattie

Please Login or Register  to view this content.