Excel found a problem......

[orsm6]

Hi all - this thing is driving me mad and I am in need of some suggestions that may not be found by googling.

I have created a workbook with a handful of sheets that all of which contain tables.
Every time I enter a new row into the table I am getting the message: Excel found a problem with one or more formula references in this worksheet.


What I have done to try and resolve:
- No protection on any sheets
- All cells are formatted to locked (but as I mentioned above, no protection)
- I have tried the "Error Checking" on every single sheet and they now all say none found
- Name manager does not appear to be returning any REF errors

I am unable to see any 'error' arrows in the cells to find the problem.....

TIA for any thoughts you could offer

 

[awoohaw]

Maybe you can share a sanitized version of your workbook to a share site so forum members. You may get a quicker response.
Thanks in advance.

 

[orsm6]

Maybe you can share a sanitized version of your workbook to a share site so forum members. You may get a quicker response.
Thanks in advance.

yeah thought about that... i'll try to work out how

ta mate