Problem

The Jira Cloud for Excel add-on changes the query of all the saved Workbooks when you change the query in any of the open workbooks copied from one of the closed ones

How to Replicate

1. Create a workbook and use the Jira Cloud for Excel to populate it;
2. Save it as Book 1
3. Copy the Workbook as Book 2 and populate Book 2 with a different JQL
4. The JQL in Book 1 will be updated on disk even though the data won't change
5. If you copy Book 3 from Book 2 and populate it with a different JQL, the queries in books 1 and 2 will be updated too to match the new query in Book 3.
6. The customer devices are using the following settings:
   • OS - MacOS Ventura 13.0.1
   • Excel - Office 365 version 16.68 (22121100)

Suggested Solution

(Add a suggested solution once one has been determined)

Why This Is Important

(Add a description for why this is important)

1. The customer wants to be able to save the query that generated the data in each workbook

Workaround

(Add a workaround, if available)

1. The workaround is to open a new workbook each time and recreate the formulas