+ Reply to Thread
Results 1 to 6 of 6

Error message when first opening Excel

  1. #1
    Forum Contributor
    Join Date
    06-25-2013
    Location
    Longview, TX
    MS-Off Ver
    MS365
    Posts
    338

    Error message when first opening Excel

    Hello all!

    **This is a question I posted on another site about a month ago and didn't get any responses so I thought I'd try here. Here's a link to that post: https://www.mrexcel.com/forum/excel-...d-problem.html **

    Recently, I suddenly developed a problem that I've never seen before. I was attempting to open a spreadsheet from a website - I've opened this report every day for months with no problem. But that time, I got a box saying:

    "Excel cannot access 'Daily Reports'. The document may be read-only or encrypted."

    Trouble is, there's no document/spreadsheet anywhere on my computer or on the Common Drive (Network) called 'Daily Reports'; there IS a folder by that name on the Common Drive but no document.

    When I click OK in that box I get another box that says:

    "'Daily Reports' cannot be accessed. The file may be corrupted, located on a server that is not responding, or read-only."

    I click OK on that and then the document I was trying to open (which is NOT called 'Daily Reports') opens up fine.

    If I already have Excel open, this issue doesn't happen. But anytime Excel is not currently open, no matter what workbook I try to open - or even just opening Excel at all - causes the exact same errors, always referring to 'Daily Reports', even if the workbook I'm trying to open is not located in the 'Daily Reports' folder. For example, if I have a workbook saved only on my desktop and go to open it, Excel gives me the error messages and, once I've clicked OK on each of the messages, it opens fine. Once Excel itself is open, I can open anything with no troubles, but if I close Excel and then later go to open a workbook, I get to see the errors again.

    The path to the 'Daily Reports' folder is: Computer>common$(ID info)>Imports>Daily Reports.

    I've googled for hours and searched this site, but none of the suggestions helped. I followed the instructions to find anything that might be trying to open automatically on opening Excel, but, as far as I can tell, there's nothing!

    Anybody know what's up &/or how to make it stop? I mean, it only takes a few seconds, but it's just annoying.

    Thanks

    Jenny

  2. #2
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,900

    Re: Error message when first opening Excel

    Hi, are there any addins loaded ?
    What's in your XLSTART folder?
    A previous recorded macro in your PERSONAL.xlsb?
    Not much to go on with the information you provided.
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

  3. #3
    Forum Contributor
    Join Date
    06-25-2013
    Location
    Longview, TX
    MS-Off Ver
    MS365
    Posts
    338

    Re: Error message when first opening Excel

    Awww, I can't believe this! I swear I checked in the XLSTART folder last week and there was nothing in there except PERSONAL.XLSB, but now that I've looked again, there's a Daily Reports folder! I feel stupid!

    So, can I just delete that folder from XLSTART? Or will that somehow delete or affect the "correct" Daily Reports folder that's on the network drive?

    Thanks

    Jenny

  4. #4
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,900

    Re: Error message when first opening Excel

    You can either move it elsewhere, then you still have it, but do remove it from there because everything that's in that folder is executed at startup of Excel

  5. #5
    Forum Contributor
    Join Date
    06-25-2013
    Location
    Longview, TX
    MS-Off Ver
    MS365
    Posts
    338

    Re: Error message when first opening Excel

    I checked just to make sure, and that one was just a shortcut. The "original" folder is still where it belongs, so I deleted the shortcut and everything seems good now!

    I can't figure out how it got there in the first place! I know I didn't put it there; at least not on purpose!

    Thanks!

    Jenny

  6. #6
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,900

    Re: Error message when first opening Excel

    Well. you always have little MicroSoft gnomes that ...
    Probably using saveas, it can happen
    Glad you found it

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Error Message while opening Excel-File
    By Carteloni in forum Excel General
    Replies: 3
    Last Post: 12-06-2014, 02:26 PM
  2. [SOLVED] Error message when opening 2013 Excel in a Mac
    By mtndewgradon in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 2
    Last Post: 11-06-2013, 02:37 PM
  3. Replies: 4
    Last Post: 07-27-2012, 12:30 AM
  4. [SOLVED] compile error message on a new excel workbook opening
    By manicmollymacomb in forum Excel General
    Replies: 0
    Last Post: 03-03-2006, 06:10 PM
  5. error message when opening excel spreadsheet
    By read mail only in forum Excel General
    Replies: 0
    Last Post: 02-24-2006, 12:30 PM
  6. [SOLVED] Error Message When Opening Excel
    By Walid in forum Excel General
    Replies: 2
    Last Post: 07-27-2005, 05:05 PM
  7. Error message opening Excel
    By Ed in forum Excel General
    Replies: 1
    Last Post: 03-18-2005, 12:06 AM

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