Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Excel 2007 hangs when opening network file

Windows Software


Reply
 
Thread Tools Search this Thread
  #1  
Old 29-07-2009
Member
 
Join Date: Mar 2008
Posts: 31
Excel 2007 hangs when opening network file
  

Hello friends,

I am facing some issues whenever i am trying to open any Excel 2007 file everything works fine if i try to open it inmy computer but if the same file is on a network and if any user try to open it through Network Shared. Excel 2007 Spreadsheet takes a very long time and sometimes user gets a message as Not responding. But if left for some 20 - 30 min the file 'opens', though it's extremely slow to do so. Can any figure it out what would be the issue in it.

Reply With Quote
  #2  
Old 29-07-2009
Member
 
Join Date: Jan 2008
Posts: 3,757
Excel will not open any Files

it might happen that many users will be trying to use the same excel file because of which it opens very late and you think that it's being hang. If the size of the file is very large then also it takes a very long time in such kind of cases i would recommend you to tell user to have a copy of the same file at his computer and then try to access it and see if still he is facing same issue.
Reply With Quote
  #3  
Old 29-07-2009
Member
 
Join Date: Mar 2008
Posts: 31
Excel 2007 hangs when opening network file

If the user try to copy and paste it on my local machine and then try to open it normally and my excel file size is not so much large, i don't want such kind of things. i wan to have that file on network shared only where user comes and access that file and save it over there only. Is there any alternative solution where it won't get hangs whenever a user access it.
Reply With Quote
  #4  
Old 29-07-2009
Member
 
Join Date: Dec 2008
Posts: 164
Excel 2007 hangs when opening network file

I was also facing such kind of issue i try to follow the below steps and it worked out fro me hope it works for you too.
  1. Before going ahead please Close all your office programs.
  2. Then click on Start, click on Run and type regedit and press enter.
  3. Now registry window would get open and try to find out the following registry key:
  4. Office 2003
    • HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Common\Open Find
    Office 2007
    • HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Common\Open Find
  5. Once you find that key now point to New on the Edit menu, and then click on DWORD Value.
  6. Over here type EnableShellDataCaching, and press ENTER.
  7. Now right-click on EnableShellDataCaching, and then click on Modify. In the Value data box, type 1, and then click OK.
  8. Finally click on Exit to quit Registry Editor.
Reply With Quote
  #5  
Old 29-07-2009
Member
 
Join Date: Apr 2008
Posts: 2,139
Excel 2007 hangs when opening network file

Try to check out the below links how this will help out

Slow open/save on Word and Excel 2007 on network location.
Standard file dialogs (open, save) cause Office 2007 to hang
Reply With Quote
  #6  
Old 28-07-2011
Member
 
Join Date: Jul 2011
Posts: 1
Re: Excel 2007 hangs when opening network file

The Office File Validation patch also drags opening Excel files from a network location.

http://support.microsoft.com/kb/2501584
http://support.microsoft.com/kb/2570623
Reply With Quote
  #7  
Old 12-09-2011
Member
 
Join Date: Sep 2011
Posts: 1
Re: Excel 2007 hangs when opening network file

Thanks dwakeman!

That solved the problem here. I used


And did method three, that stopped the hangups but Excel kept trying reinstall the OFV tool with every network file open which was annoying.

So I went back and did method 4, and everything was back to normal.

For both methods I used the Microsoft Fix It option.
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Excel 2007 hangs when opening network file"
Thread Thread Starter Forum Replies Last Post
Getting Error while opening Microsoft Excel 2000 file in Excel 2003 AbiaA MS Office Support 6 17-02-2012 12:18 PM
Opening WK1 File in Microsoft Excel 2007 $horizon$ Windows Software 3 11-01-2012 05:07 PM
Microsoft Office 2007 is re-installing on opening words, Excel ElijahAllman Windows Software 5 15-04-2011 10:27 PM
Problems opening excel 2007 from XP to Vista computer tmoorehe Operating Systems 1 16-10-2009 12:25 PM
Delays in Opening Files in Excel 2007 hikari07 Windows Software 4 23-06-2009 11:17 PM


All times are GMT +5.5. The time now is 08:06 PM.