Search notes:

Excel: File -> Options -> Data

Change options related to data import and data analysis.
This feature is only available in Office 365 subscriptions.

Data options

Make changes to the default layout of Pivot Tables (Edit Default Layout…)
Disable undo for Pivot Tables with at least this number of data source rows (in thousands): nnn
Prefer the Excel Data Model when creating PivotTables, QueryTables and Data Connections.
Disable undo for large Data Model operations
Disable undo for Data Model operations when the model is at least this large (in MB): nnn
Enable Data Analysis add-ins Power Pivot and 3D Maps
Disable automatic grouping of Date/Time columns in PivotTables

Show legacy data import wizards

From … (Legacy)

Automatic Data Conversion

Remove leading zeros and convert to a number
Keep first 15 digits of long numbers and display in scientific notation
Convert digits surrounding the letter E to a number in scientific notation
Convert continuous letters and numbers to a date
Unsetting this option prevents the conversion of march1 (but not march 1!) to a date
When loading a .csv file or similar file, notify me of any automatic data conversion

Index

Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php:78 Stack trace: #0 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(78): PDOStatement->execute(Array) #1 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(30): insert_webrequest_('/notes/Microsof...', 1759612425, '216.73.216.149', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/Microsoft/Office/Excel/GUI/Ribbon/tabs/File/Options/Data/index(90): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78