Excel worksheet error messages

Gers

I have copied and then modified a personal financial workbook with a number of worksheets, all of which have formulas. It's almost the same as workbooks I have used for the past four years with a few design features.

This new one throws up two error messages whenever I open it.

First one tells me that the workbook is read only, it's not!

The second messages warns about circular references - I've checked each worksheet using the error checking option umder the formulas ribbon / financial auditing. No errors have been found.

I'd appreciate any help to resolve these problems - thanks.

scaredofdebt

Possibly corrupt?

tizerbelle

For the Read Only one, go to File > Info > then unselect the Protect Workbook option.

Gers

tizerbelle said:

For the Read Only one, go to File > Info > then unselect the Protect Workbook option.

Thanks - I was going potty! 

Now just the circular reference thing to sort out - probably (hopefully) tomorrow.

tizerbelle

Have you checked that there aren't any hidden sheets?

If nothing was showing under error checking I'd be inclined to make a number of copies of the workbook - so you can mess with the data without risk and then try deleting data / sheets one by one to see if I could pin down where the problem is.

Gers

tizerbelle said:

Have you checked that there aren't any hidden sheets?

If nothing was showing under error checking I'd be inclined to make a number of copies of the workbook - so you can mess with the data without risk and then try deleting data / sheets one by one to see if I could pin down where the problem is.

No hidden sheets. I did a 'save as' which replicated the problem so,then faffed about with a brand new workbook copying each individual worksheet across which has worked. 

Thanks so much for your advice, it really is appreciated. 😀

GDB2222

It depends on your Excel version, but there should be error-checking (perhaps under Formulas) and circular references should be one of the options.