I have a VBA sheet which seems to run really slowly on excel 2016 vs excel 2007.
The sheet contains a list of consecutive usable numbers which can be ticked off as used. When a number is clicked a tick goes into the box and the cell of that number fills green with a red line through the number showing as used.
Until today we had one user accessing the sheet from cloud storage via excel 2007 and one from excel 2016. The 2016 version always ran slow with slight lagging when a box was ticked. however the excel 2007 user found the sheet to be quite slick.
Other than the fact that both users are now on outlook 2016 can anyone suggest a fix to improve the sheet performance?
i'll hold my hands up as a beginner when it comes to VBA/Macros. happy to send the sheet for someone to look at.
Thank you in advance.
The sheet contains a list of consecutive usable numbers which can be ticked off as used. When a number is clicked a tick goes into the box and the cell of that number fills green with a red line through the number showing as used.
Until today we had one user accessing the sheet from cloud storage via excel 2007 and one from excel 2016. The 2016 version always ran slow with slight lagging when a box was ticked. however the excel 2007 user found the sheet to be quite slick.
Other than the fact that both users are now on outlook 2016 can anyone suggest a fix to improve the sheet performance?
i'll hold my hands up as a beginner when it comes to VBA/Macros. happy to send the sheet for someone to look at.
Thank you in advance.