I have an shared Excel workbook that has a macro for auto save (update), The problem users are having is while working on different excel workbooks not linked to the shared workbook, when the auto save starts on the shared workbook all other excel workbooks become inactive until the auto save is complete.
Is there a macro to stop other workbooks from becoming inactive when the shared workbook starts auto saving?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!