I have several worksheets that cause the following problem.

Open worksheet, run some code

basically ask for a selection, and run a query (MS Query) and then update a
pivot table

the weird thing is if i choose exit and save or exit and don't save i get
the

Microsoft Excel has encountered a problem and needs to close.

Does anyone have any suggestions?