Excel Formula Copying

T

tlsGR

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)

Recently, whenever I copy a formula in excel, the resulting display stays the same as the original formula. If I double click into the cell, the cell references have been updated, and once I have double-clicked or "entered" the cell, when I leave, the answer is updated.

However, this is not a workable solution, as I often copy dozens or hundereds of formulas, and don't like going "into" each and every cell to get the correct answer.

Do you know why this is happening?

Alos, this problem correlates with a recent Microsoft upate that I was prompted to download... not sure if they are directly related or not.
 
C

CyberTaz

Don't know about the correlation, but it may resolve the problem if you go
to Excel> Preferences> Calculations & make sure the sheet is set for
Automatic.
 

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