up vote 3 down vote favorite
share [g+] share [fb]

I have an excel spreadsheet with several connections, that are set to refresh automatically (Refresh Data when opening the file). I think there is a problem with one of the queries because it hangs upon opening and I can't even see what it is trying to execute. Is there a way to open the file w/o the auto-refresh?

Thanks,

Max.

link|improve this question
67% accept rate
What version of Excel? – JNK Sep 3 '10 at 13:51
@JNK: the file itself is .xls, I think it's in 2003 format. I'm using 2007 to open it. – Meringros Sep 3 '10 at 13:55
feedback

2 Answers

up vote 2 down vote accepted

Assuming you're using Excel 2007, you should do the following:

In Excel Options, navigate to Trust Center > Trust Center Settings > External Content. You'll see the Security Settings for Data Connections and Workbook Links. Disable both.

Additionally, navigate to Formulas tab, click Manual under Calculation options, and then click OK. Restart Excel and you're done.

link|improve this answer
Thank you Mehper, it worked. – Meringros Sep 4 '10 at 3:23
You're welcome. – Mehper C. Palavuzlar Sep 4 '10 at 9:34
feedback
up vote 2 down vote

OK, in Excel 2007, go to excel options:

Office Button -> Excel Options at the very bottom.

At the bottom of the Advanced options, check "Ask to update Automatic Links

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.