I have an excel file that I use to gather data from a query. Then I use sum and sumif formula's to group the data how I want. It was working just fine and then I decided I would update the query and in doing so removed some columns. I have started to update the corresponding formulas, but have hit a snag. There are very simple formulas (simple A6+B6) formula's that don't update. On the Summary Sheet, look at cells H35 and F45. I can't figure this out. I don't want to do this all over, but even if I did am worried that I will be right here where the formula's aren't updating and thus I am stuck. If I do a formula evaluation, it will show the values up to the last one and then reverts the formula to 0. FYI, this is not because the calculation in the file has changed to manual.
Thanks,
PS> There could be some circular reference errors thru this. I stopped moving on to correct other formulas when I came across the one's where there wasn't a circular reference but the formula's were not working.
Bookmarks