Click the folder where you want to add a new workbook. I've tried recreating the issue on 4 other machines, laptops and desktops, but everything works fine. Is this happening to other users or just one specific user? A cloud icon means this item is not actually on your PCs storage drive. Huh! To continue this discussion, please ask a new question. Find the option for "Default open behavior for browser-enabled documents", and select "Open in the client application". I am going to give it until tomorrow and then close the discussion if he is still running smoothly. Here is more info. So as this no longer happens, my question is now moot. A copy of that file or folder (and any files inside the folder) is downloaded to your PCs storage drive so its always available, and it stays in sync with the copy thats stored in the cloud. Welcome to the Snap! I go through the post carefully, per the description, it seems that you can not use File>Save/Save as button to save Office files. c. Open the Excel application> Check whether you can save the file as .xls Also, You can set up Mac in safe mode according to this article: Start up in safe mode. you can only save files when closing it and save it to OneDrive, as "On My Mac" doesn't work. As seen in attachment. Find out more about the Microsoft MVP Award Program. If you delete a file or folder in OneDrive on your PC, its deleted from the cloud as well. Sometimes, Excel has issues opening an Excel file and displaying the data due to hardware acceleration for the graphics card in the computer. Here is what that should look like: Excel (and presumably other office apps) can also give the following error because OneDrive settings. You need t SysAdmin Day is THIS WEEK! 66K views, 821 likes, 1.3K loves, 9.7K comments, 1.5K shares, Facebook Watch Videos from Pentecostal Assemblies of the World, Inc.: July 18th, 2023 ~. xxxx_2), - Copy the file back to the network share, place in same location, - Try to open the file you just renamed and copied to the network share, Just a guess try cleaning the excel cache. The network has a firewall and the PC is running Win defender. I checked almost all of the Document Library settings, but so far no luck. You can access OneDrive files and folders in File Explorer. Adobe Attach File via Link Encryption Issue, https://support.microsoft.com/en-us/kb/2626998, HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Policies\System. You can upgrade to 100GB storage for $2 per month or purchase a Microsoft 365 plan, which includes the desktop versions of Outlook, Word, Excel, and PowerPoint, starting at $7 per month for 1TB of OneDrive storage. You need t SysAdmin Day is THIS WEEK! Next: Updated Intel WIFI driver from Lenovo website. Will you even be at work, or are you going on Legacy ExchangeDN Configuration and Outlook Issues. The best answers are voted up and rise to the top, Not the answer you're looking for? Airline refuses to issue proper receipt. I'm wondering if this has anything to do with what's going on. Sometimes, when a user opens a saved workbook or document, it is blank. OneDrive works the same way whether youre using it through an individual, business, or enterprise account, except as noted below. If someone could lend me a hand in trying to figure this out, I would really appreciate it. Any other advices? Here's how to do it. However As I started to recreate the situation for screen shots, I now see that feature is working as expected--something has been corrected or changed since the last time I ran into this. (If your company uses Outlook or you have a free account on Outlook.com, then you already have a Microsoft user account. 4.Adding the network folder location to Trusted Locations. Can't open excel file in edit mode, currently open by 256 users, Excel 2013 workbook will not open in client application from SharePoint, only browser, Open a link of Excel with the dialog popup window in quick launch SharePoint 2010, Sharepoint Excel file opens Read Only when edit is selected. Then on occasions it will let the user save to their local desktop. It seems the problem occurs also when the files are stored locally on the computer, so it's not a network issue. I'm not aware of any VBA codes. unless they happen automatically, I haven't created any And why would the VBA code do that on some workbooks but not others??? Your daily dose of tech news, in brief. Please update your answer with more details. In the Ribbon, click the File tab and click Options in the left navigation pane. ), or you can invite specific people to view the file or folder. You can share files or folders in your OneDrive with anyone by sending them a web link to it. Go back to your OneDrive account to find your newly created sheet. Sharefile plugin in Outlook causing attachment problems for some IO Can you color code email accounts in Outlook? If you change and save a file in OneDrive on your PC, the new version will replace the older version stored in the cloud. We have Office 2010 standard. Its built into Windows 10. The steps above reset the default file associations for Microsoft applications. Flashback: July 24, 1951: Transistor Inventor Leaves Bell Labs (Read more HERE.) Excel links open files as read-only mode. Enter data and edit your worksheet as desired. it just the way I like to work (old dog, new tricks). Choose Save As and select the location. You can disable the hardware graphics acceleration in Excel by following the steps below. To select/change file associations manually, in step #3 above, select the Choose a default app by file type or similar option in the search results. Copyright 2021 IDG Communications, Inc. Hello Alex, The "Open in the client application" was already the current setting. Can a Rogue Inquisitive use their passive Insight with Insightful Fighting? In the Send link panel, you can invite only specific people to have access to a shared file, and control whether they can edit or only view the file. Try these steps: Open the Excel file > File > Options > Save > Check the option "Save to Computer by Default". There are a few other options on the Link settings panel, but you can only use them if youve subscribed to at least a OneDrive business plan: Set expiration date lets you enter a date when you want the link to no longer work. AutoSave is available when a file is saved to Microsoft OneDrive or SharePoint in Microsoft 365, but you need to save or open the file from within Excel, PowerPoint or Word to switch it on. yes, the formulas are converting to hard-coded values after I hit save. If he logs in anywhere else, the issue doesn't occur. Given her modify rights. Bonus Flashback: July 24, 1950: First Launch from Cape Canaveral (Read more HERE.) @ChristianJBergstromThank you for responding and for the links. Selecting Free up space means files stored in the cloud won't be downloaded until you click on them. If you use the method that I showed above and select "edit" after clicking on the document link in the Library, I don't see how it could say the file is read only if you open it in edit mode. Uncheck this box if you want all your files to be available offline. Browse other questions tagged, Start here for a quick overview of the site, Detailed answers to any questions you might have, Discuss the workings and policies of this site. I believe I understand the basic concepts involved with the Autosave feature (Word, Excel, Powerpoint). Shown from left to right in the image above: To remove a file or folder in OneDrive on your PCs storage drive but keep it in the cloud: Right-click its name, and from the menu click Free up space. Is the laptop connected to your network on a wired or wireless connection? 1. Up until recently if I created, say a spreadsheet, and saved it in My Document and Closed it. That will happen if it hasn't. Under ), Individuals get 5GB of OneDrive storage for free. Later I move the file from my documents to the OneDrive folder, ReOpened and enable Auto-Save, I would be prompted to upload it to OneDrive (odd since I had already moved the file to folder and I would have expected it to be synced and recognized as being on OneDrive). Something more specific with this computer or office. Making statements based on opinion; back them up with references or personal experience. On the next panel, click the Account tab and the Choose folders link. This has been replaced by 'Save as Copy', but even if I save a copy before I make any changes, the original document still seems to pick up the same changes. Anyone with a Microsoft 365 subscription can also use the desktop versions of these Office apps to work together on the file. If you copy the files to the local drive and open them from there, does this still happen? This topic has been locked by an administrator and is no longer open for commenting. Will be glad for any help. Keep in mind that if you have a lot of files in your OneDrive, it may take a while for them to be downloaded to your PC, especially if any file is large in size. Here's how: Open your OneDrive account. So a couple troubleshooting steps I'd try. It is already in OneDrive at this point, so why upload a second copy which then syncs back to my Local OneDrive folder. Open the problematic Excel workbook. In the right pane, under the Save documents section,. The OneDrive app shows OneDrive files and folders that have recently been changed. If youre uncomfortable sending out a link that anyone can share with others, you can instead invite specific people to the file or folder. You can then paste this web link to your file or folder into a document, direct message, email, etc. An email will be sent to these people that contains a link to your file or folder that only they will be able to open. Additionally, an add-in might have disabled the AutoSave. I'll edit this post when I have any settings suggestions to try. But only the formulas that are calculating from other tabs in the workbook. (If theyre in your contacts, you can just start typing their name and select from the suggestions that pop up.) You need to untick the following box in the OneDrive settings. With it you can sync files on your Windows 10 PC to the cloud and to your other Windows PCs, your smartphone or tablet (with the OneDrive app for Android, iOS, or iPadOS installed), and even your Mac (via the OneDrive Mac app). rev2023.7.24.43543. Click on File from the top-left corner. If this backup feature is on, then when youre using Word, for example, your document files will be saved to the Documents folder in OneDrive. Sharefile plugin in Outlook causing attachment problems for some IO Can you color code email accounts in Outlook? I don't see any add-ins that could be causing the issue. These add-ins sometimes cause problems with opening Excel spreadsheet files. When you put a file or folder into OneDrive on your PC, it is synced to the cloud. When a file or folder is in the process of syncing to the cloud, the icon by its name will have two blue arrows animating in a circular motion. to share with other people. Looking for story about robots replacing actors, Physical interpretation of the inner product between two quantum states. Method 1: Use the same account to sign in to the Microsoft 365 app and OneDrive Select the OneDrive icon ( ) in the taskbar notification area. No amount of changing Trust Center settings in Excel will fix it. Take a look at Excel Add-Ons, I had a similar problem where a special app had installed its add-on and was causing similar problems. On some of the workbooks (no rhyme or reason I can find), any formula that is pulling data from another spreadsheet within the same workbook reverts to the formula's result every time I save the workbook, instead of saving the formula itself. SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. If we rename the file it will open fine the first time. On the next panel, uncheck one or more folders that you want to stop from syncing to the cloud. Can a creature that "loses indestructible until end of turn" gain indestructible later that turn? You can also select a file type association specifically for Excel worksheets only by following the steps below. I had similar issue with Lenovo X260 running Windows 10 Pro 64 bit. You are using an out of date browser. From there you can close out of the file that's stuck. Type your new file name, then click Rename. The problem still persists though. The files are located in a network shareon our local server. If you are unable to turn on the AutoSave feature in Excel, it could be because the file contains features that are not supported by AutoSave. If I decide that I want Autosave after this point, the desktop software tells me I need to upload a copy to OneDrive. Unchecking the "open email attachments in reading view". Which Excel functions can ignore hidden rows? This would be late enough that any people working remotely wouldn't be affected, but would still make sure that any open files would be closed before they got stuck as read-only. A user is experiencing an odd problem. Again, this is still only with the password protected file. From the menu that opens, click Share next to the blue cloud icon. Was the release of "Barbie" intentionally coordinated to be on the same day as "Oppenheimer"? Re: Clarification on OneDrive and Autosave, https://support.microsoft.com/en-us/topic/what-is-autosave-6d6bd723-ebfd-4e40-b5f6-ae6e8088f7a5. ), Signing in to OneDrive. Cause There are several reasons why a file may open as read only: Antivirus programs may open potentially unsafe files as read-only. Arethesebeing opened as attachments from Outlook? Confusingly, this setting may or may not be on when you sign in to OneDrive. Select Help & Settings ( ) > Settings. This would remove the window Alex was referring to and allow the user to see a yellow bar at the top of the Excel window that allows them to edit the document. Seems this doesn't happen locally (as for as the user tried), and the problem also happened with my word document when i stored it in the network and kept it open while i was away from the pc for the weekend (the computer was in sleep mode). We are called Lucky 13 Farms and are about 80% self sufficient for food at this time. Problem is in trusted web. Two ways to go about this: blast away and rebuild her profile (or try with a different users profile) or reinstall Office. Open Microsoft Excel. Set password lets you enter a password which a person will need to provide in order to access your link. Ahhh yes, this is definitely the issue we ran into then, but unfortunately I don't have a fix for it. 2. Some work and school accounts have additional options on this panel, letting you choose to allow access for anyone with the link, only people in your organization with the link, only people with existing access to the file or folder, or only specific people.