External References in Excel

F

Francist

Hi,

I have been sent an excel sheet with a lot of data. When opening, the
program request whether I wish to update values, which I don't (also I have
set to manual Calculation in options) as I do not have the source data.
However, after clicking the "Don't update" button, it will still start to
calculate causing all cells with to have value "#Ref".

Hopefully you can help me in this matter.

regards,

Francis
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top