Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    Dec 2009
    Location
    warren, ohio
    Posts
    66
    Thanks
    1
    Thanked 13 Times in 6 Posts

    very long load and save times with excel 2007 windows 7

    We have mapped a network drive where we store common spreadsheets used at month end. When I was using xp and windows 2003, the spreadsheets opened and saved normally, within 5-10 seconds or less.

    Now I have a honkin' fast windows 7 computer and excel 2007. I have mapped the same network drive. It takes at least 60 seconds to open the spreadsheet and another 60 seconds to save it.

    These are very simple sheets, about 10 rows by 10 columns or so and have been converted to .xlsx format.

    Arf there any logs in windows 7 or excel that can help pinpoint the long load/save times? I have both excel 2003 and 2007 installed (to avoid the ribbon when possible). I have noticed, on occasion, some startup template messages, so perhaps this is the problem. Or otherwise related to both 2003 and 2007 being installed.

  2. #2
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    New York, New York, USA
    Posts
    266
    Thanks
    0
    Thanked 19 Times in 19 Posts
    D:

    One thing that may help, before running the Macro set Excel 2007 Security to the lowest level. Then run your Macro.
    After the Macro is done put the security back to the level your IT Group has as the default.


    Hope this helps.

    TD

  3. #3
    Star Lounger
    Join Date
    Dec 2009
    Location
    warren, ohio
    Posts
    66
    Thanks
    1
    Thanked 13 Times in 6 Posts
    there are no macros involved. I set it to allow all, it still took a long time.

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    If you store them on a local drive, do they have them problem? If not the issue would seem to be with the network settings. Sometimes it can be an issue with anti-vrius settings and needs to be worked out with IT personnel.

    Steve

  5. #5
    Star Lounger
    Join Date
    Dec 2009
    Location
    warren, ohio
    Posts
    66
    Thanks
    1
    Thanked 13 Times in 6 Posts
    yes,this is probably network issue. I copied the spreadsheet to my hard drive and it loaded normally, within a few seconds.

    Word documents also take about 45-60 seconds to open from the network drive. PDF files on the network drive opens in about 10 seconds with acrobat reader. (PDF files open quicker from the local hard drive) Text files on the network drive open instantly with notepad. Microsoft security essentials is the anti virus. So being on a network drive only affects microsoft office stuff, not other files.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •