calculation

[Patrick]

Hi,

I work with 3 large excel files (5000 KB). File A is my
summary and is linked with the 2 others. I use a lot of
reference cells and I discovered that some reference cells
does not work. Some cells do not calculate
automatically. I saved everything on the C drive in order
to minimize the lenght of the formula but I still have
problems.

Any idea what else I could do?

Thanks in advance.

 

[Tushar Mehta]

Can you share some examples of the cells that don't calculate? What is
the formula in one of them? What's different between that cell and one
that does recalculate?

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions