1. I have sheets: AS1, AS2 and AS3
2. Created name: "=A1 - B1"
I want that name to work everywhere but seems that is impossible. Name manager added sheet name to formula as "='AS1'!A1 - 'AS1'!B1". Now, it works everywhere but it always referers to AS1 sheet only and I didn't want that.
Is it...