A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Excel table-centric protection and validation
Rashedul Haque Ronjon
6
Reputation points
The following 'should be'/'can be'/'will be' possible in the case of improving excel tables/database:
- When adding, editing, or deleting records/columns containing "formula/function, formatting, sorting and filtering" which is connected to or dependent on primary/foreign key relationship,
then informing/preventing users about the particular relationship constraint with messages, notifications etc. before restricting/performing the action. - Provision for implementing foreign/primary key constraints based on "unique value", "auto-incremental number" etc.
- Using automatically incremented integer/float value, Time()/Now() and/or Date()/Today() function as primary key with automatic update for Now() and/or Today() function on/off.
- Provision for implementing SQL queries as general functions and/or formulas.
Thanks and best regards.
My courtesy from the bottom of my heart to Microsoft Windows and Office, and the entire Microsoft Office team for providing me and people like us all around the world with this very powerful and effective software and valuable suggestions.
Microsoft 365 and Office | Excel | For business | Windows
Microsoft 365 and Office | Excel | For business | Windows
Sign in to answer