THE FILE FORMAT OR FILE EXTENSION IS NOT VALID. the message 'EXCEL CANNOT OPEN THIS FILE. The file that I keep in my dock just wont even open. This did change formulas back to values but rounded them to nearest dollar. One file is a blank icon that says 'user/username/trash.hd' (I definitely did not trash anything). All of a sudden, all my values resulting from a formula in any cell changed to the formula. If you still need help, select Contact Support to be routed to the best support option.Īdmins should view Help for OneDrive Admins, the OneDrive Tech Community or contact Microsoft 365 for business support. I was working on an Excel spreadsheet in Office 365 Home. Need more help?įor help with your Microsoft account and subscriptions, visit Account & Billing Help.įor technical support, go to Contact Microsoft Support, enter your problem and select Get Help. Learn how to Find lost or missing files in OneDrive or View historical versions of Office files. See more information about how long deleted items are kept for work or school accounts. If you're signed in with a work or school account, items in the recycle bin are automatically deleted after 93 days, unless the administrator has changed the setting. Your sheet will open on the Sheets editing screen. On the Sheets site, select the sheet youd like to convert to Excel. Log in to your account if you arent already. If your recycle bin is full, the oldest items will be automatically deleted after three days. First, on your Windows, Mac, Linux, or Chromebook computer, launch a web browser and head over to the Google Sheets site. If you're signed in to OneDrive with a Microsoft account, items in the recycle bin are automatically deleted 30 days after they're put there. For more information about SharePoint versioning settings (which also apply to OneDrive for work or school) see Enable and configure versioning for a list or library or How does versioning work in a list or library? You can retrieve 25 previous versions of your file with a personal Microsoft account. If you're using OneDrive as part of SharePoint Server, your administrator may have turned off document versioning. So if you mean by 'original' that it is (before I create the copy) the only file for that spreadsheet in the system (once again with its many versions) than yes. Just be aware restoring an earlier version will overwrite the current file. This allows you to roll back changes to recover unsaved work or reverse accidental saves over important data. Select the version to restore and click Restore. If you sign in with a work or school account, the number of versions will depend on your library configuration. If I make a copy of the spreadsheet (which already has multiple versions saved for it) its the latest version of that spreadsheet. For Excel 2013 and earlier, the steps are: Go to File > Info > Previous Versions. Click Restore to overwrite the current version. Find the Manage Workbook section and locate the file version you wish to recover. If you sign in with a personal Microsoft account, you can retrieve the last 25 versions. Click File, then select Info from the dropdown menu.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |