Page 2 of 3 FirstFirst 123 LastLast
Results 11 to 20 of 27

Thread: Failing to Find File
Thanks Thanks: 0 Likes Likes: 0

  1. #11
    Board Regular bobsan42's Avatar
    Join Date
    Jul 2010
    Location
    Bulgaria, GMT+2 (42.891813,25.313594)
    Posts
    1,281
    Post Thanks / Like
    Mentioned
    6 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Failing to Find File

    Normally this folder is used to store macro-enabled files which auto-start with excel. But nothing will end up there on its own.
    Normally you should always check (esp. when having a problem) what files are loaded - visible or not: in VBE - Project Explorer - it shows them all

    Glad you figured it out.
    "...it's sad that in our blindness we gather thorns for flowers..."
    mostly using:
    windows 7 +10 (64-bit) / excel 2013 +2016 (32-bit) / access 2013 +2016 (32-bit) / some imagination & Google of course
    You don't need to read between the lines - just read them all!

  2. #12
    Board Regular
    Join Date
    Oct 2018
    Posts
    525
    Post Thanks / Like
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Failing to Find File

    and I lied....didn't solve it the next time I went to use excel...

    So I removed all of the code from the ThisWorkBook page- most of which were macros for running when opening/closing. This hasn't changed excel- so I'm back to wondering if this was an installation problem

  3. #13
    Board Regular bobsan42's Avatar
    Join Date
    Jul 2010
    Location
    Bulgaria, GMT+2 (42.891813,25.313594)
    Posts
    1,281
    Post Thanks / Like
    Mentioned
    6 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Failing to Find File

    I had a similar problem some time ago but it was caused by an add-in I am building up from time to time. Changing a few settings in excel fixed it for me.
    I doubt it is an installation issue, although a reinstall may fix it. Probably something else is loading in the background causing this. Disabling graphics hardware acceleration and changing DDE settings helped in my case .

    Check the list of loaded workbooks and addins in VBE(Alt+F11) / Project Explorer (Ctrl+R) - if anything is out-of-place or just in case try to disable /remove everything but the current workbook and check for a change.
    However strange this may seem - check if the workbook is not back in the XLSTART folder.
    Also check and disable all other addins one-at-a-time: Excel Options / Add-ins / Manage
    Last edited by bobsan42; May 3rd, 2019 at 01:53 AM.
    "...it's sad that in our blindness we gather thorns for flowers..."
    mostly using:
    windows 7 +10 (64-bit) / excel 2013 +2016 (32-bit) / access 2013 +2016 (32-bit) / some imagination & Google of course
    You don't need to read between the lines - just read them all!

  4. #14
    Board Regular
    Join Date
    Oct 2018
    Posts
    525
    Post Thanks / Like
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Failing to Find File

    So I had thought along similar lines as you-

    already disabled all addins- namely just solver
    already checked workbooks/projects, and the XLSTART folder is clear.

    So interesting because I just went back to double check everything- so workbook on the desktop- double click to open- excel opens a blank window- checking- there's no workbook open and vba says no workbook as well just to confirm. Double click the workbook again and it opens as it should (this has been acting the same all along, but just to clarify to myself...)

  5. #15
    Board Regular bobsan42's Avatar
    Join Date
    Jul 2010
    Location
    Bulgaria, GMT+2 (42.891813,25.313594)
    Posts
    1,281
    Post Thanks / Like
    Mentioned
    6 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Failing to Find File

    weird ...
    "...it's sad that in our blindness we gather thorns for flowers..."
    mostly using:
    windows 7 +10 (64-bit) / excel 2013 +2016 (32-bit) / access 2013 +2016 (32-bit) / some imagination & Google of course
    You don't need to read between the lines - just read them all!

  6. #16
    Board Regular bobsan42's Avatar
    Join Date
    Jul 2010
    Location
    Bulgaria, GMT+2 (42.891813,25.313594)
    Posts
    1,281
    Post Thanks / Like
    Mentioned
    6 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Failing to Find File

    May be association problem after all...
    But is it just this file ... Does it open correctly the second time if you close the empty application window before this?

    Check for some ideas here: https://www.mrexcel.com/forum/excel-...first-try.html
    "...it's sad that in our blindness we gather thorns for flowers..."
    mostly using:
    windows 7 +10 (64-bit) / excel 2013 +2016 (32-bit) / access 2013 +2016 (32-bit) / some imagination & Google of course
    You don't need to read between the lines - just read them all!

  7. #17
    Board Regular
    Join Date
    Oct 2018
    Posts
    525
    Post Thanks / Like
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Failing to Find File

    Nothing in that forum to work :/

    And no- if I close the window and then attempt to reopen the workbook I get the blank, open window (unloaded excel window)

  8. #18
    Board Regular bobsan42's Avatar
    Join Date
    Jul 2010
    Location
    Bulgaria, GMT+2 (42.891813,25.313594)
    Posts
    1,281
    Post Thanks / Like
    Mentioned
    6 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Failing to Find File

    did you try checking the File type association?
    Is it only this file (of the same type e.g. xlsm) that behaves like this? if YES then don't bother with the above and maybe upload a copy of the file so that me or someone else can inspect it.
    Although from what you say I gather that the file only loads if the app i pre-loaded. Which is weird and means something at application level - still not sure what it can be ...


    What is the file location (path and file name)?
    Did you check your trust center settings?
    What is your system setup - OS, Office, version ?
    Last edited by bobsan42; May 3rd, 2019 at 04:02 AM.
    "...it's sad that in our blindness we gather thorns for flowers..."
    mostly using:
    windows 7 +10 (64-bit) / excel 2013 +2016 (32-bit) / access 2013 +2016 (32-bit) / some imagination & Google of course
    You don't need to read between the lines - just read them all!

  9. #19
    Board Regular
    Join Date
    Oct 2018
    Posts
    525
    Post Thanks / Like
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Failing to Find File

    OS - Windows 10 Pro
    Office 2016 Professional Plus - build- 11601.20144 (version 1904)

    Path was desktop (C:\Users\Austen\Desktop\**myworkbook**

    File type assocation- so it seemed like it was just .xlsm (i.e. this workbook) but tweaking DDE and graphics seems to make it worse- now the only way to actually load a workbook is to open excel and the from within the excel window, open a workbook. Clicking the icon again won't open excel....not good.

    I am happy to send you the workbook personally. I'll pm you my email and you can shoot me an email and I'll return it with the workbook. I very much appreciate your help.

    Also note- this laptop that is having this issue is not connected to the internet...and won't be until Tuesday at the earliest. I can transfer stuff to it via flash drive though.

    I don't see anything out of the ordinary in trust center settings.
    No add-ins active now.
    Graphics Acceleration disabled. DDE not checked

  10. #20
    Board Regular bobsan42's Avatar
    Join Date
    Jul 2010
    Location
    Bulgaria, GMT+2 (42.891813,25.313594)
    Posts
    1,281
    Post Thanks / Like
    Mentioned
    6 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Failing to Find File

    just sent you a PM with my mail address

    Fix you settings back to normal if it's not helping.
    Can you confirm one more thing.
    When you first open the file and you end up with a blank Excel window - in the VIEW tab, next to Freeze panes there is a button labeled UNHIDE - is it active or grayed out?
    "...it's sad that in our blindness we gather thorns for flowers..."
    mostly using:
    windows 7 +10 (64-bit) / excel 2013 +2016 (32-bit) / access 2013 +2016 (32-bit) / some imagination & Google of course
    You don't need to read between the lines - just read them all!

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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