fishysheep
Programmer
Hi
working with excel wb that had become very bloated over time. Code in wb.open to clear all sheets (formatting, formulae and data), drawing objects, names, shapes and links. That's worked to reduce file size (20% of original) but once the code has finished running I can't click on a sheet - there is a delay of about 5 seconds. During this delay the cursor doesn't change, but if I repeatedly click the sheet then I title bar of excel shows flashes "not responding" and then all is well. It's not the code itself because if I add it to a new wb, works as expected and there is no delay - sheet can be clicked straight away.
I'm assuming that despite having deleted formatting, data, formulae, objects, shapes, namedranges and links there is still something else lurking. Any ideas?
no protection on sheet and excel startxl is empty.
working with excel wb that had become very bloated over time. Code in wb.open to clear all sheets (formatting, formulae and data), drawing objects, names, shapes and links. That's worked to reduce file size (20% of original) but once the code has finished running I can't click on a sheet - there is a delay of about 5 seconds. During this delay the cursor doesn't change, but if I repeatedly click the sheet then I title bar of excel shows flashes "not responding" and then all is well. It's not the code itself because if I add it to a new wb, works as expected and there is no delay - sheet can be clicked straight away.
I'm assuming that despite having deleted formatting, data, formulae, objects, shapes, namedranges and links there is still something else lurking. Any ideas?
no protection on sheet and excel startxl is empty.
