How to Fix common Excel spreadsheet problems & errors

Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 25th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to interpret and resolve the nine most common Excel formula errors — namely, ####, #NAME?, #N/A, #REF!, #VALUE!, #NUM!, #DIV/0!, Circular Reference, and #NULL!.

3 Comments

Hi I have created document on Exel which I am constantly editing. Whenever I try to save it it says read only and I have to keep saving the same document under a new name. I have been creating document this way for the last 2 years and this hasn't happened before. Can someone tell me how to disable the read only element permanently?

Go to where the file is saved right click on it and select properties. See if the the read only option is selected and un check it and save. Then re open the excel file.

If that is what is occurring then it could be the folder options making everything read only in that folder perhaps.
OR

Start>All Programs>Microsoft Office>Microsoft Excel>Click Office Orb>Open The Document>Click Office Orb>Select Save As>Click Tools Button>General Options>Un check "Read Only" option>Save = Complete and free of read only mode for the document.

I TRY TO USE THE DATA FILTER AND IT SAYS NO ITEM FOUND ALTHOUGH THE ITEM IS ON MY SPREADSHEET SOMETIMES IT WORKS MOST OF THE TIME IT DOESN'T WHAT CAN THIS BE?

Share Your Thoughts

  • Hot
  • Latest