asked on

Updating Sources in Excel 2007 Spreadsheet freezing

I have an excel spreadsheet located on a server elsewhere. The way I access the document is via a network share located on that server setup as a network drive on my computer. My computer is a Windows XP Pro SP3 ThinkPad laptop and I am running Office 2007 suite. When I open that excel spreadsheet it takes a couple of seconds being that it's located on a server outside the building but when I try and update the sources after I'm through with the changes I made to the document, the spreadsheet freezes forcing me to stop the excel process and reopen excel again. There are about 12-13 other spreadsheets linked to this one spreadsheet all in the same share (Folder) located on the same server, so that shouldn't be an issue. I was wondering if it could be the excel 2007 app because on excel 2003 when trying the same updating process it doesn't freeze but it lags for a couple of seconds. Any help would be greatly appreciated.

redrumkev

robo187,

How are you doing?

Do you have SP1 for Office 2007?
http://www.microsoft.com/downloads/details.aspx?FamilyId=9EC51594-992C-4165-A997-25DA01F388F5&displaylang=en

Kevin

robo187

ASKER

I'm checking on the SP I have installed for office.

robo187

ASKER

How can I tell what service pack I have? However I do remember downloading and installing a huge Office update when I first installed Office 2007.

redrumkev

Ok - you can locate the version by going (Office Button -> Excel Options (bottom Right) -> Resources (left pane) -> last line (right side) says SP1 MSO?

Kevin

robo187

ASKER

I have service pack 1 installed, I just figured out how to view it.

redrumkev

robo187,

How are you doing?

What kind of formula's and updates are in use? I am wondering if there are in-efficiencies that cause the problem and ultimate crash of the App.

On the formula tap (then far right, Calculations) -> Calculation Options -> You can select manual. This will not auto calculate. Make your changes, then push "calculate now". Then save. See if this keeps it from crashing.

Are any of the linked spreadsheets missing?

Can you copy all of these spreadsheet files over to your local computer? If after copying them and running the spreadsheet locally, does it still crash?

Kevin

robo187

ASKER

Hey Kevin thanks for prompt responses. Updating is working now. It still takes awhile to complete the process once she highlights all the sources and clicks the update button. But the spreadsheet is not turning white and timing out and as I mentioned before with excel 2003 it never froze but it did take awhile to update. I also disabled Norton Antivirus Corporate edition client on her system for an application I was installing and forgot to reenable it. So it's also possible that Norton could have been interrupting the process with Office 2007 and not with Office 2003. I will alert you of my findings and thank you again for the help. Could it possibly be the connection to that server, which is in South Carolina. I'm in New Jersey.

ASKER CERTIFIED SOLUTION

redrumkev

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

robo187

ASKER

kevin, your solution makes perfect since and that's what I'm going to suggest to the user. Copy everything over locally, make all the changes and then copy it back and overwrite the file. I appreciate you pretty much spelling everything out for me.

Thanks,

Robert

redrumkev

Robert,

No problem at all and thank you for the kind words!

Also, thanks for the grade!
Kevin