coping formulas from one cell to another
For some reason when I copy a formula from one cell to another it copies the
formula, but also the value that was in the copied cell. I had no problem with this before on this spreadsheet |
Probably you're calculation is set to manual, or you have another workbook
open whose calculation is set to manual, or it just hadn't had enough time to update the cells yet (the case when many, many rows). ************ Anne Troy www.OfficeArticles.com "greg" wrote in message ... For some reason when I copy a formula from one cell to another it copies the formula, but also the value that was in the copied cell. I had no problem with this before on this spreadsheet |
coping formulas from one cell to another
I think you got it Anne. :)
Fyi, if you hit F9 and it updates, pretty sure that's the problem. -- Regards, Zack Barresse, aka firefytr "Anne Troy" wrote in message ... Probably you're calculation is set to manual, or you have another workbook open whose calculation is set to manual, or it just hadn't had enough time to update the cells yet (the case when many, many rows). ************ Anne Troy www.OfficeArticles.com "greg" wrote in message ... For some reason when I copy a formula from one cell to another it copies the formula, but also the value that was in the copied cell. I had no problem with this before on this spreadsheet |
All times are GMT +1. The time now is 03:37 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com