Setting Defaults For Excel Exports
To get Q to remember preferences for Ignore NET and SUM and the Advanced settings:
- Select all the tables in a project.
- Press the Export to Excel button.
- Uncheck Ignore NET and SUM.
- Modify the Advanced settings as per your requirements.
- Press OK twice.
Any tables that are then created by duplicating tables will remember these defaults. However, there is no way to:
- Have Q apply the same settings in new projects.
- Change the defaults other than by repeating the above process.