Display the File Name & File Path in Excel (PC & Mac) December 16, 2013 January 18, 2018 by Vinai Prakash Many a times, it is good to Display the location of the file in Excel. Hi, I'm lost on what to do with this one. We have an Excel file on our network shared drive that is accessed by different people from different offices. Two offices connect remotely. We tested the file last week and everything was working as it should so when a user had the file open Excel would notify us with the 'file is locked for editing by' message and so on. However, today we have opened the file from the shared drive and the Excel file will only open as 'Read Only'. I have checked on the server and the file isn't open by anyone else but yet we still cannot edit unless we save as a new file. I've checked all the check boxes for Read only and they aren't checked, not too sure where to go. Any help appreciated. Thanks Krystal. Go to the server that the file is hosted on, open up command prompt and type in ' openfiles' without the quotations of course. This'll give you a full list of files open on that server. Here is a screen cap of what you may see (all my file names, and user names are blocked out along with my domain info, sorry buddy). Once you fine the problem file type ' openfiles /disconnect /ID ID#' where the ID# is the file you're having a problem with. This happened last week for me as heads up, a users computer crashed and somehow didn't close a file and it remained connected after a reboot, had to do this to close 15 open PDF's that wouldn't close. Free engine diagnostic software. Chad 2420 & RAM. - I had tried both ways you mentioned to search see if the file is open and it is not open. Christina4185 - Hi, yes remote users open it within Excel 2003 and the creator opens it in Excel 2010 (forgot to mention this) CookieG - nothing permission/security wise has changed since last week when it was working fine. Matthew5942 - We did this last time with the original file as that started opening as read only so we saved as a new file even named it NEW and this has now got the same read only on open issue Bryce Katz - I saw this one and we don't have it set up on the computers to preview file when selected Thanks. Krystal - if the file isn't accessed by too many people, I'd say to check to make sure no one has the preview pane enabled (unless you have it blocked by policy). We don't set that up here either, but a few of our users figured out how to change the view settings to show the preview pane. We get this issue every here and there and the only thing that fixes it is a reboot of our file server. It's a pain in the butt to do during the day, so we usually just tell our people to save the file as a new copy, then after I reboot the file server I can remove the old one. Krystal wrote: I have just tried opening it via remote desktop logging in as the last user that modified the document and it opens fine and I can save changes but when I try open it from my computer it is still saying read only. Does this help anyone?Almost helps. Which Excel worked and what is on your desktop? I may have the answer. Well, I previously removed my comment, so here is the solution: Are you using Compatibility pack' for the Excel 2003 users? The issue is that the spreadsheet is using enhanced features, such as conditional formatting, or other feature that 2003/Compatibility cannot handle so it is opened as read-only in order to protect the integrity of the workbook. Important: Even if you have AutoRecover enabled, you should save a file frequently while you are working on it to avoid losing data due to an unexpected power failure or some other problem. AutoRecover is described later in the topic 'Save AutoRecover information automatically.' When you save a file, you can usually change its name, storage location, and file format all at the same time, if you want to do so. However, you might not want to do all of those things, and the instructions in this topic describe each option individually. Office allows you to save files in online folders provided by OneDrive and SharePoint. If you have accounts that give you access to these services, you can save and access files stored on these services much like files stored on your computer. Driver for epson stylus photo 1400. SharePoint services and OneDrive for Business are typically offered by an employer or organization, but you can use OneDrive on your own. For more information about these services, see the related topics in. To save a file to an online location other than the default folder, use Save as. You can save files from Word, Excel, or PowerPoint directly to folders on OneDrive and SharePoint services.
0 Comments
Leave a Reply. |