lawyerlagniappe
New Member
- Joined
- Nov 11, 2021
- Messages
- 1
- Office Version
- 365
- Platform
- MacOS
Hi all,
I would like to be able to filter or sort a table without Excel considering it as a change to the spreadsheet. In other words, I want to be able to open a workbook, filter or sort a column in a table, and then close the workbook without Excel prompting me to save changes. Is this possible?
I have searched for the answer here and elsewhere, but I haven't found anything (maybe I haven't used the proper search terms). Additionally, protecting the sheet while allowing filtering and sorting does not work--it still prompts me to save.
If it matters, here's my goal: when working all day on several large spreadsheets, I don't want filtering or sorting to count as a change when I close the workbooks. I worry that I will click "Save" on workbooks where I made unintentional changes (unrelated to filtering or sorting) or click "Don't Save" where I made intentional changes. I'm sure there are other ways around this, but solving the above issue if nothing else will be best for my mental health. If the save changes dialog box pops up when I did nothing but filter a table, even if I know I didn't make any changes other than filtering, the perfectionist in me will be unsettled. I'm only a little crazy, I promise.
Thanks in advance,
LL
I would like to be able to filter or sort a table without Excel considering it as a change to the spreadsheet. In other words, I want to be able to open a workbook, filter or sort a column in a table, and then close the workbook without Excel prompting me to save changes. Is this possible?
I have searched for the answer here and elsewhere, but I haven't found anything (maybe I haven't used the proper search terms). Additionally, protecting the sheet while allowing filtering and sorting does not work--it still prompts me to save.
If it matters, here's my goal: when working all day on several large spreadsheets, I don't want filtering or sorting to count as a change when I close the workbooks. I worry that I will click "Save" on workbooks where I made unintentional changes (unrelated to filtering or sorting) or click "Don't Save" where I made intentional changes. I'm sure there are other ways around this, but solving the above issue if nothing else will be best for my mental health. If the save changes dialog box pops up when I did nothing but filter a table, even if I know I didn't make any changes other than filtering, the perfectionist in me will be unsettled. I'm only a little crazy, I promise.
Thanks in advance,
LL