Results 1 to 6 of 6

Memory Error on Network drive files

Threaded View

  1. #1
    Registered User
    Join Date
    05-08-2015
    Location
    Manitoba, Canada
    MS-Off Ver
    2013
    Posts
    4

    Memory Error on Network drive files

    I'm not sure if this is an appropriate place for this, but I'm having some odd memory errors and I'm not sure what may be the cause.

    On a network drive, I try and open some macro enabled worksheets that range in size from ~100KB to ~450KB (still relatively small). Excel opens them in Protected View and lets me enable editing, but as soon as I click on a cell it freezes, crashes, and gives me the following error:

    There isn't enough memory to complete this action.
    Try using less data or closing other applications.
    To increase memory availability, consider:
    - Using a 64-bit version of Microsoft Excel.
    - Adding memory to your device.

    Now the odd thing is that if I copy the file to a local location (like my desktop for ease) and then open it, everything works normally. I can then go ahead and save the file back to its network location and continue working on it (without closing and reopening Excel of course). If I then close Excel and reopen the file from its network location, I get the same memory error.

    This doesn't happen with all files, only a select few. I've attached one of the problem ones so if you see something out of the ordinary in it, let me know. This file is essentially just a stormwater balancing file; what it's doing isn't as important as the error I get upon opening it.

    There are no external files being referenced whatsoever, and no real extensions aside from the default ones.

    This is all in Excel 2013 (32 bit) running in Windows 7 64 bit on a Xeon 1620V2 with 8GB of Memory.

    I'd be very appreciative if someone could pinpoint the problem here as I'm at a loss. I don't have the CD/Serial Number for Office so uninstalling/reinstalling isn't a great option for me at this point (could be done but not ideal).

    Thanks,
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Hyperlink to .pdf files saved on network drive
    By carlw in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-03-2017, 12:21 PM
  2. Using Links to Network Drive files in Excel 2010
    By estratosphere in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-02-2015, 05:38 AM
  3. Macro Will not work to process files stored on network drive.
    By rmingram in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-01-2014, 03:31 PM
  4. Save files to a Mapped Network Drive on server
    By wotsup in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-12-2012, 11:46 AM
  5. Error Moving Sheet from Network Drive
    By realniceguy5000 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-21-2008, 10:23 AM
  6. [SOLVED] Excel creates .XAR & .TMP files on network drive
    By OWN3D!!1 in forum Excel General
    Replies: 1
    Last Post: 11-16-2005, 01:52 PM
  7. Connection error to network drive
    By dmlw96 in forum Excel General
    Replies: 0
    Last Post: 09-30-2005, 04:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1