Hi all,
New forum member, I found that this forum is excellent for questions and troubleshooting. I'm working on a previous edited workbook for my job. Using Excel 2016, I had recently converted the designated worksheet into a table. It was previously not in table format. The sheet has conditional format rules. Very simple ones i.e. "If yes turn red" "If no turn green". It has rules for numerical conditions too. Basically just less than greater than. I decided to take the worksheet further, after adding in drop down menu's for specific columns. Long story short, I've attempted to add data form visual pop-up menu for easier record keeping. However, every time I select the table and click on data form. The program ctd's, then will restart with repair flag on the workbook.
My question is, what could be causing this crash? What kind of troubleshooting methods, may I employ to remedy this issue?
I've searched youtube and google for various answers, but I haven't found any info.
Thank you in advanced.
Best regards
New forum member, I found that this forum is excellent for questions and troubleshooting. I'm working on a previous edited workbook for my job. Using Excel 2016, I had recently converted the designated worksheet into a table. It was previously not in table format. The sheet has conditional format rules. Very simple ones i.e. "If yes turn red" "If no turn green". It has rules for numerical conditions too. Basically just less than greater than. I decided to take the worksheet further, after adding in drop down menu's for specific columns. Long story short, I've attempted to add data form visual pop-up menu for easier record keeping. However, every time I select the table and click on data form. The program ctd's, then will restart with repair flag on the workbook.
My question is, what could be causing this crash? What kind of troubleshooting methods, may I employ to remedy this issue?
I've searched youtube and google for various answers, but I haven't found any info.
Thank you in advanced.
Best regards
