I am having a HUGE problem and was wondering if anyone else has experienced this and and may know a fix.
I am doing a query from an external data source (MS Access DB) and using that data to create a pretty intensive report. The query itself is not huge, the bulk of the report is additional cells added based on various fomulas applied to the data returned from the query. Everything goes along beautifully until I refresh my query. When I do that it tells me that Excel experienced and error and is closing. From there both my last saved copy and the auto recovered version have lost their links to the external datasource. This has now happened 3 times and I am in a panic because I don't know what is causing it or how to make it stop and I have a deadline to get this working by this tuesday!
Is this happening to everyone or is it perhaps something I am doing incorrectly?
HELP!!!!!!
I am doing a query from an external data source (MS Access DB) and using that data to create a pretty intensive report. The query itself is not huge, the bulk of the report is additional cells added based on various fomulas applied to the data returned from the query. Everything goes along beautifully until I refresh my query. When I do that it tells me that Excel experienced and error and is closing. From there both my last saved copy and the auto recovered version have lost their links to the external datasource. This has now happened 3 times and I am in a panic because I don't know what is causing it or how to make it stop and I have a deadline to get this working by this tuesday!
Is this happening to everyone or is it perhaps something I am doing incorrectly?
HELP!!!!!!