2 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Checkboxes not transferring properly between Google Sheets and Excel

Hey folks!

A while ago I created a simple little spreadsheet in Sheets for the purposes of making my job of creating a work schedule easier. The idea is simple: each employee has a row, with three columns for each work day. For each day there is an "Off?" section that has a checkbox, and columns for "In" and "Out".

Checking the checkbox sets off a Conditional Formatting rule for the cells in the next two columns over that greys out those two cells. It looks like this. https://imgur.com/a/tlxEorz

Admittedly, this was very cumbersome to do and that makes me reluctant to scrap it all and work from a different starting point.

Only problem is that when I export it as an excel file and pull it up, all of my checkboxes are gone and replaced with TRUE/FALSE text. I see that checkboxes function differently in Excel than they do in Sheets, but I don't exactly understand it.

The conditional formatting does still work if I type in TRUE/FALSE, but I want to be able to interact with a checkbox like I can already do in Sheets but my Insert Checkbox button is greyed out no matter what I do. The workbook is unprotected, so I'm not sure what's going on.

Does anyone have any ideas on how to get this functioning in Excel? It won't necessarily need to be transferable back to sheets, I really just need it functioning in Excel because that's what my new job uses.

[Microsoft 365 MSO (Version 2601 Build 16.0.19628.20204) 64-bit]

submitted by /u/Calm-Surprise-5005
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#Excel compatibility
#natural language processing for spreadsheets
#generative AI for data analysis
#google sheets
#rows.com
#financial modeling with spreadsheets
#modern spreadsheet innovations
#machine learning in spreadsheet applications
#enterprise-level spreadsheet solutions
#digital transformation in spreadsheet software
#row zero
#collaborative spreadsheet tools
#AI-driven spreadsheet solutions
#cloud-based spreadsheet applications
#automation in spreadsheet workflows
#no-code spreadsheet solutions
#checkbox
#Google Sheets
#Excel