Running Windows 10 & Office 2010.
1. Most of my Excel workbooks work fine...when no macros used.
2. My "budget" workbook has slow performance & freeze issues...it uses macros.
3. Some/most slowness is due to many imbedded, conditional formulas in 12 sheets.
4. Open & close workbook is slow.
5. But my big concern is that Excel freezes when I select the File Tab...I have to force close Excel.
6. I use a Personal.xlsb file. I don't really need it since I have only one workbook using macros.
7. I have tried the Office Repair feature. I have NOT reinstalled Office.
8. I have tried MANY fixes (which work for other users) such as Safe Start/Delete addins/Changing Trust Center options/etc.
9. I'm left to focus on the macro issue.
10. Could it be the Personal.xlsb file? Should I stop using it? How can I go back to imbedded macros in the workbook?
11. I had this issue before Windows 10. I have struggled with this for many years.
Thanks for any help.
1. Most of my Excel workbooks work fine...when no macros used.
2. My "budget" workbook has slow performance & freeze issues...it uses macros.
3. Some/most slowness is due to many imbedded, conditional formulas in 12 sheets.
4. Open & close workbook is slow.
5. But my big concern is that Excel freezes when I select the File Tab...I have to force close Excel.
6. I use a Personal.xlsb file. I don't really need it since I have only one workbook using macros.
7. I have tried the Office Repair feature. I have NOT reinstalled Office.
8. I have tried MANY fixes (which work for other users) such as Safe Start/Delete addins/Changing Trust Center options/etc.
9. I'm left to focus on the macro issue.
10. Could it be the Personal.xlsb file? Should I stop using it? How can I go back to imbedded macros in the workbook?
11. I had this issue before Windows 10. I have struggled with this for many years.
Thanks for any help.