0

Good day, yesterday the workbook worked just fine, today the Structured Reference in any object doesn't work, in example picture 1 I select with the mouse or arrow keys "E2", and it doesn't get the Table name nor reference, but if I write the name of the table or reference it shows (I must add the "use reference" option is enabled.

enter image description here

enter image description here

Tried unable save close and re-enable then save close again, not working sadly).

The workbook behaves the same if saved as a no-macro file, a binary or a non-xml file, this does not happen with other workbooks in the same PC, tried opening in other PC and same behaviour.

Is there something i can try?

Improve this question
3
  • 1
    File >> Options >> Formulas >> Use Table Names in Formulas ? Commented Jun 26, 2023 at 20:42
  • It was enabled, i tried unchecking it, saveing close and reopen, then check it save, close and reopen, no luck. Commented Jun 26, 2023 at 20:54
  • 1
    Maybe you have converted this 'table' to a range and Table1 is showing because you have a table named Table1 in another worksheet. Commented Jun 26, 2023 at 23:22
Related questions
0
Workbook.SaveAs crashes Excel with some workbooks but not others
2
How to convert dynamic (structured) reference in Excel to fixed cell value?
3
Excel VBA 2010: Data validation breaks when workbook saved by VBA, but not when saved manually
Load 2 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.