Thank you very much for your help. I guess, the Splash Screen is a UserForm, e. Thanks Sounds like a security issue within office itself. Microsoft recommends using 32-bit Excel in most cases source: but does list 'large data sets' as a reason for trying 64-bit source:. I just honestly don't know how to retrieve that info before deleting that file. Yes, this problem is only on the patricular laptop.
Open Excel File Using Open and Repair Feature Step 1. I thought it was going to be an issue but I haven't heard from them so maybe they just don't open docs from the server. It allows you to within just 3 simple step. I had to erase the following registry keys to get it to reset. Regarding the second proceudre you mentioed, I double clicked My conputer icon and went to Tools. We've used an clean install and we can see all our network drives.
The files I needed to open only contained data. In the Open dialog box, click to select the inaccessible Excel file. I did the retrieval again from my Passport backup and chose the option to place the files in a designated location. Here are the steps that I copied and pasted from a website I found with the fix: 1. But I did not find the same path name you mentioned. Would you like to answer one of these instead? Verify that the file has not been corrupted and that the file extension matches the format of the file.
We beat on this for a couple of days and discovered this post. How many records are you mentioning? The start of each day all my Excel files open very small. If you need further assistance regarding this issue, please feel free to post back and we are glad to help you. Just for your information incase it applies to you not necessarily : Thank you for your new suggestion. Based on Freya's comment, it seems unlikely Microsoft will fix the problem -- it's a feature, not a bug, dontcha know.
So, I don't know from where the big drawing came from. However, if I look at the properties of the file, they clearly indicate the file is an excel file and opens with excel 2016. For testing, disable and isolate the conflict by turning off each add-in one at a time. Or, to put it another way: Windows is weird. Once I did that I could open the Excel files with no problem.
Besides, please try going to the Domain Controller, select Computers, right click Win 10, select Reset Account to see the result: Best regards, Yuki Sun Please remember to mark the replies as answers if they helped. Am I looking at the right place? Note to forum moderator: I firstly tried to upload a zip file having a dot in its name, e. About how to repair Office in Windows 10, please refer to this article: Hope it's helpful. I waited at least 5 minutes and nothing happened. Do you have any formulae in this particular file? I tried to opend the file afterwards without success. Since any file in the startup folder opens first it sets the size.
I tried all of the possible fixes in the below article but that did not resolve the issue. Normally they hang at 0% on the Excel splashscreen, I think if you leave them for 15 mins they sometimes open. Do you mean the issue only happens to this particular laptop? Since I had done a clean install on my laptop none of my original locations were there. My issue is I created this workbook using excel 2016. Note: The default value is 0 which disables the validation. If I went to Apps Excel was not listed even though I could open excel navigate to a file and open it.
Any other suggestion about what could be done? I was not able to open some of excel files from network share but if I copy and paste on my local desktop, then they open up. May be, if you disable the Splash Screen, it could in a first step help. Kind regards, Paul Problem solved. Browse other questions tagged or. So many weird quirky dumb problems with 2016 as I'm sure can attest to. Best regards, Yuki Sun Please remember to mark the replies as answers if they helped. Thank you for your answer.
Which version of Excel do you use on your computer? Change the file extension to. Resolution To resolve this problem, try the following methods, as appropriate, in the given order. But again, when I download the file to the local disk, I can open it. I would change to a database application if possible. It will work when I put the code in, but once I save and re-open I cannot make multiple selections from the drop down list.
Or are you copying from the server, onto something like a flash drive, and then transferring them over? It opens them with everything in one column flagpole style, down column A, with commas and speech marks visible. Here is what it looks like. Excel was not able to open the file though. To do this, see the following Microsoft Knowledge Base article: Hotfix Package 1 for Microsoft User Experience Virtualization 2. Note You may have to restart your computer after the repair process is complete. Excel will launch and act as though it is opening the file, but ultimately never does.