Formula
 

When I have a worksheet that I opened through Internet Explorer and I copy a
formula to a cell, the formula will be copied correctly but the value is not
correct.

Example If the formula in Cell J1 is =+h1*$G$8 and I copy this formula to
cell J2-J5 the formual will be =+h2*$g$8 for cell J2 and so on. If the
displayed amount in cell J1 is 250, then the amount for cell J2-J5 will be
250, which is incorrect.

This only occurs when the file in opened through IE, if I were to save the
file to my local drive and reopen it only through Excel the formula function
correcly.

Does anyone know how to correct this?

Formula
 

Sounds like you have Calculation set to 'Manual' for the Internet Explorere
worksheet.
HTH,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"Confused Excel User" wrote:

When I have a worksheet that I opened through Internet Explorer and I copy a
formula to a cell, the formula will be copied correctly but the value is not
correct.

Example If the formula in Cell J1 is =+h1*$G$8 and I copy this formula to
cell J2-J5 the formual will be =+h2*$g$8 for cell J2 and so on. If the
displayed amount in cell J1 is 250, then the amount for cell J2-J5 will be
250, which is incorrect.

This only occurs when the file in opened through IE, if I were to save the
file to my local drive and reopen it only through Excel the formula function
correcly.

Does anyone know how to correct this?