Hi, I am brand new to this forum, driven here by frustration! I use several different workbooks for my business but only one of them has form controls; some columns have tick boxes and others have dropdown menus of about 3-4 choices. I have a tab for each month so 12 in total and each of them has 28 columns, with half this number having controls in them. Rows are somewhere between 30-40 each month. Document size is about 5mb. I'm giving you all this info because I don't know what part might be relevant. Basically it is not a huge file. It has been working fine for nearly 2 years but suddenly I have a problem where every entry or change that I make, be it in a control box or not, it hangs for anywhere between 20 seconds and 2-3 minutes. It doesn't crash but just takes ages. My other Excel files are fine and unaffected but every tab on this workbook has the same issue. I have looked at AddIns in safe mode and none of them are ticked (should they be?). It is autosaved to OneDrive but I have tried turning autosave off and no difference. This is driving me mad now and taking up most of my day either using it and being patient or spending time trying to find an answer. Hopefully someone can help me.
Bookmarks