Forum Discussion
Checkboxes: currently unreconcilable differences between Excel Online and Excel 2024
I started working on a database that I thought would be simple. I start with a product list. Each inventory item in that list needs a quality control check from each of 6 departments. In each ro...
May considering below:
- Using VBA Macros:
- Since Excel 2024 requires VBA macros to efficiently add checkboxes to large datasets, you might consider learning some basic VBA. There are many online resources and tutorials available to help you get started.
- Hybrid Approach:
- Continue using Excel Online for adding checkboxes and setting up conditional formatting. Once your setup is complete, download the file and use Excel 2024 for offline work and monitoring with the floating watch window.
- Alternative Tools:
- If Excel continues to be problematic, you might explore other tools like Google Sheets or specialized project management software that can handle your requirements more efficiently.