Updating formula results
I am having the following issues:
1. When I copy and paste a formula to different cells, the results do not reflect the correct data! It only takes the data from the first cell, although the formula is correct 2. When the data is updated, the formula results do not automatically get updated Is there somewhere to go to for making it automatic? This is the first time I am encountering such issues!!! |
Updating formula results
Hi,
I'm not sure I fully understand the question but perhaps calculation has been changed to manual Tools|Options - Calculation tab and select automatic. Mike "I-Gek" wrote: I am having the following issues: 1. When I copy and paste a formula to different cells, the results do not reflect the correct data! It only takes the data from the first cell, although the formula is correct 2. When the data is updated, the formula results do not automatically get updated Is there somewhere to go to for making it automatic? This is the first time I am encountering such issues!!! |
All times are GMT +1. The time now is 03:50 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com