98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Excel
Excel
Resolved · Medium Priority · Version 2003
Tiniker has attended:
Excel Introduction course
Excel
Why is it atfer a spreadsheet is already set up, and formulas entered, that the spreadsheet becomes corrupt, the formulas no longer work.
RE: Excel
Hello Tiniker,
Hope you enjoyed your Microsoft Excel course with BEST Training.
Thank you for your question regarding spreadsheets and formulas.
There are many reasons why formulas can become corrupt.
Here are some ways that it can happen.
1.
By default all the cells in Excel are unprotected. This means that anyone could intentionally or mistakenly change the content of the cell at any time.
2.
People using the spreadsheet may not know that the formula exists and so in making changes to the data, errors can occur.
3. If the data that a formula is refferring to is changed or moved, that can cause the formula result to become an error.
4. The formula itself may be changed. If someone clicks into a formula and then by mistake enters even a single keystoke, that can cause a formula to be incorrect.
I hope this resolves your question. If it has, please mark this question as resolved.
If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?
Have a great day.
Regards,
Richard
Microsoft Office Specialist Trainer
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Selecting blank cells within a range of dataSelect the range of data which includes the blank cells that you would like to select. Press the F5 key, this will take you to the GoTo dialogue box where you can click on Special and then select Blanks. |