Forum Discussion
no links/VBA/addons, but : Microsoft excel waiting for another application to complete an ole action
I agree David, it should not be happening. However, if it's any help, I believe I know why it's happened this time around. By the way, charts are notorious for this.
If you create a chart in excel, presumably it will be based on data (a table of some sort). If you cut or copy the chart to another tab, it will still show the correct values (as it's linked to the original data). If you cut or copy it to an email, powerPoint or anywhere alse, it wil remain linked to the original data. You've deleted the original (temporary) spreadsheet and Excel is an unhappy bunny!
Unfortunately, I don't have a fix for this and I suspect Microsoft don't either, as it would require them adding a timeout code or a way to break unmatched links.
However, for future cases, I'd suggest pasting the chart as a picture i.e. rather than using a normal paste use paste special.
I know it doesn't help in this case but in the past when I've faced the problem, I've looked for VBA code or used Excel tools like Inquire, to see if I can fix the problem. Other than that, I've had to dissable my addins (in some cases removing them) and reinstalling.
All I can say is it's bloody annoying!
