The first method is by clicking “More options” and adding folders using the Explorer window that pops up. You have two options for creating new folders. Now, select “Save a Copy” from the left pane. Open any of your workbooks in Microsoft Excel and click “File.” For better organization, you should create separate folders for various projects, or at least one folder each for every Office app. xlsx file because the format or extension is not valid. WORKAROUND Excel prompts you to grant access to files and then hangs or shows a warning that it cannot open the.
FIXED Excel does not respond when using 'Save as Picture'. However, that’s also where all other Office documents will be saved, which can lead to a lot of clutter. Excel for Mac crashes and slow performance. RELATED: What Your Function Keys Do In Microsoft Excel Change Where Excel Workbooks Are Saved in OneDriveīy default, Microsoft Excel saves your Excel workbooks in the Documents folder in OneDrive.
You should note that you’ll need an internet connection for autosave to work correctly and sync these workbooks across devices. You’ll just have to enable autosave once every time you start working on a new Excel workbook, and you won’t need to save it again. From here on out, Excel will keep saving any modifications you make to this workbook. That’s all you need to do to enable autosave. You’ll see a pop-up window that asks you where you want to save your workbook. Right at the top, you’ll see an option labeled “AutoSave.” Click the toggle next to AutoSave to change it to “On.”
