Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reusing formula | Excel Discussion (Misc queries) | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |