Excel Downlad Not Showing Correctly On A Mac

Because fonts work with the operating system, they are not downloaded to Office directly. You should go through the system's Fonts folder in Windows Control Panel and the font will work with Office automatically. On the Mac you use the Font Book to add the font and then copy it to the Windows Office Compatible folder. If you use Microsoft Excel on your Mac, you can save the spreadsheets you create and open them in Numbers, Apple’s spreadsheet app. It’s a handy feature to use in case you can’t.

-->

Note

Office 365 ProPlus is being renamed to Microsoft 365 Apps for enterprise. For more information about this change, read this blog post.

Symptoms

When you work with a Microsoft Excel file, you receive one of the following messages:

Cause

The above memory error messages can be generic and don't always identify the real cause of the issue. However, if your file is large or contains a large number of features, it is possible you are running low on available memory resources.

Before we explore the more common reasons for the memory errors, it good to understand Excel's limitations. See the following resources for more information:

If you are not hitting a resource limitation, these are the most common resolutions.

Resolution

Follow the provided methods in this article to resolve the available resource error message in Excel. If you have previously tried one of these methods and it did not help, go to another method from this list:

Method 1: Contents of the spreadsheet

The first thing to determine is if the error is specific to one workbook (or others created from the same template). Typical actions that cause memory error messages are:

  • Inserting a row or column
  • Sorting
  • Performing calculations
  • Copy and pasting
  • Opening or closing the workbook
  • Running VBA

If you are seeing the error when performing any of the above actions, it's time to look to determine what is going on in your file. These will be addressed in the sections below.

Calculations

If you are inserting rows and columns, performing calculations, or copying and pasting and receive the message, it can be tied to formulas having to recalculate.

Consider this scenario:

You have a spreadsheet with 1 million formulas on a sheet and you insert a new column. This will force Excel to recalculate all the formulas in the spreadsheet adjusting for the new column that you inserted. It is possible, depending on the complexity of your spreadsheet, bitness of Excel, and how the spreadsheet is built, and what formulas are used, that you receive the out of resources error.

The following articles address how to optimize performance with calculations:

Other Spreadsheet Elements

Other areas that can cause the memory issues are excess shapes, complex PivotTables, macros, and complex charts with many data points. The following article walks through identifying and fixing these issues.

Custom Views in a Shared Workbook

If you are using the feature Shared Workbook (Review Ribbon > Share Workbook), cleaning out the Custom Views may help with available memory. To do this;

  1. On the View Ribbon
  2. Custom Views on the dialog choose Delete

Deleting Custom Views doesn't delete anything in the spreadsheet, it does delete the print areas, and filters. These can easily be reapplied.

If your issue is not resolved after you clean up the file, go to method 2.

Method 2: Verify/install the latest updates

You might have to set Windows Update to automatically download and install recommended updates. Installing any important, recommended, and optional updates can frequently correct problems by replacing out-of-date files and fixing vulnerabilities. To install the latest Office updates, click the link specific to your version of Windows and follow the steps in that article.

Operating system updates:

Office updates:

For more information about Office updates, see Office downloads & updates.

If your issue is not resolved after you install the updates, go to method 3.

Method 3: Add-ins interfering

Check the Add-ins that are running, and try disabling them to see if Excel is working properly. Follow the directions in the following article to disable the add-ins.

If you find that Excel is no longer giving you the error after you remove the add-ins, then it is recommended to contact the manufacturer of the add-in for support.

If your issue is not resolved after you remove the add-ins, go to method 4.

Method 4: Test disabling Preview/Details Pane in Windows 7

Excel Download Not Showing Correctly On A Mac Hard Drive

If you are running Windows 7, try disabling the preview and details panes in Windows. You will have to disable them in three locations.

Windows Explorer:

  1. Right click on Start button
  2. Click Open Windows Explorer
  3. Click Organize | Layout
  4. Uncheck Details Pane and Preview Pane

Excel:

  1. Click File | Open
  2. Click Organize | Layout
  3. Uncheck Details Pane and Preview Pane Outlook:
  4. Open a new e-mail
  5. In the 'Include' group on the Ribbon, click Attach File
  6. Click Organize | Layout
  7. Uncheck Details Pane and Preview Pane

If your issue is not resolved after you turn off preview and details panes, go to method 5.

Method 5: Test a different Default Printer

When Excel launches, it uses the default printer to help render the file. Try testing with the 'Microsoft XPS Document Writer' as the default printer and see if we continue to get the error. To do this;

  1. Close Excel
  2. Open the printer and faxes window (XP) or Devices and Printers (Vista, 7, 8, 10)
  3. Right-click the 'Microsoft XPS Document Writer' printer
  4. Click Set as Default

If your issue is not resolved after you change your default printer, go to method 6.

Method 6: Test without Antivirus

Antivirus can sometimes cause problems by continuously trying to scan the Excel file or something in the file. Many times the memory error will be random and will be found with any spreadsheet. Test this by shutting off the antivirus temporarily, or by not having Excel files scanned. In some cases, the AV will need to be removed.

If your issue is not resolved after you turn off antivirus, go to method 7.

Method 7: Test with 64-bit version of Excel

Working with large Excel files can use the memory available to the 32-bit Excel application. In any 32-bit application there is a 2-GB limitation.

If your processes need to use more than 2 GB's, then you need to carefully consider moving to Microsoft Excel 64-bit version. The 64-bit version will allow all available physical RAM on the machine to be used. If you are interested in researching 64-bit versions, see 64-bit editions of Office 2013.

If your issue is not resolved after testing on 64 bit, go to method 8.

Method 8: Other applications are consuming the computer's memory and not enough is being allocated to Excel

Does the message clear up for some time after you reboot or shut off some of your applications? That's probably a good sign this is your issue, follow the steps to shut down some of the extra applications running on your computer.

More Information

Additional article

If the information in this article did not help resolve the error in Excel, select one of the following options:

  • More Microsoft online articles:Perform a search to find more online articles about this specific error
  • Help from the Microsoft Community online:Visit the Microsoft Community and post your question about this error
  • Contact Microsoft support:Find the phone number to contact Microsoft Support

Files not showing in folder in Window 10 or Windows Explorer not showing all files or folders may happen when meeting a virus attack or Windows update. If you are troubled by this issue and want to recover the disappeared files, you can make it by changing the viewing feature, using CMD, or applying a professional data recovery software.

Workable SolutionsStep-by-step Troubleshooting
Fix 1. Unhide filesClick on 'Start' > type folder options in Search > click View...Full steps
Fix 2. Use cmdClick on 'Start' > type cmd in Search > type: attrib -h -r -s /s /d e:*.*...Full steps
Fix 3. Use file recovery softwareDownload file recovery software > choose a location to scan > preview and recover...Full steps

Files not showing up in the folder

Excel Download Not Showing Correctly On A Mac Trackpad

'When I connect my USB drive to PC and try to open a folder for data transfer, I couldn't see any files. I'm quite sure that I have stored some important working documents there. It seems that something goes wrong and make the folder not showing files. Is there any way to find and retrieve my data back?'

Folders not showing up in Windows file explorer

'I saved my family pictures and videos in two different folders on my laptop, but when I double click to access my data, Windows File Explorer not showing the folders just like they have never existed. It drives me crazy! Please help me fix the issue.'

As you can see from the two situations mentioned above, the issue of files not showing up in folder usually happens in two cases: folder not showing files and Windows File Explorer not showing folders. And sometimes, you may also get an error message says 'This folder is empty'. If you are also a victim encountering these two problems and can't access your data on a hard disk, USB drive or other memory storage devices, you can use the following three data recovery solutions to find a way out.

Note: Here, if you encounter 'folder won't open' issue and are prevented from accessing your data, please refer to how to fix File Explorer won't open in Windows 10 to get a solution.

What Cause Files Not Showing up in the Folder

Many factors can cause files not showing in folder or Windows Explorer not showing folders. The possible reason is that some malware or virus attack your hard disk, USB drive, or other memory storage device. And all these threats can hide or even delete your files so that you won't see them in the folder. And some users report that Windows 10 update also can be one of the causes. Whatever the reason might be, try the solutions below to recover virus-infected files and fix the issue.

How to Fix Folder Not Showing Files in Windows 10/8/7

Downlad

If the folder not showing files in Windows 10 results from virus attack and get hidden, here are three ways you can try to unhide your files.

Fix 1. Using Unhiding Files Feature

Excel Download Not Showing Correctly On A Mac File

1. Click on 'Start' > In the search box, type folder options, and press Enter.
2. In the Folder Options window, click on the 'View' tab.
3. Check the option 'Show hidden files, folders or drives' and uncheck the 'Hide protected operating system files'.
4. Click the 'OK' button to save all the changes.

At most time, these steps will help you unhide missing folders/files which were hidden by the virus. So, open the device to check if your files are showing up in the folder after all the operations. If it does not help, try the second way.

Fix 2. Using CMD

1. Click on 'Start' > In search box, type cmd.
2. Right-click the Command Prompt and choose 'Run as administrator'.
3. Type: attrib -h -r -s /s /d e:*.* and hit Enter. (Replace e: with the drive letter of your device where want to recover shortcuts files)

The command will quickly find and recover your hidden files or folders. When it finished, refresh and check your external hard disk or USB drive, you will find that folder not showing files issue is fixed, and all your files are there.

Manual input of the command line is suitable for computer professionals since wrong commands can cause more severe problems. Therefore, for security and usability, we strongly recommend you try an automatic command line alternative. EaseUS Tools M is a practical tool that enables you to check and fix files system error, enable/disable write protection and system update with one-click instead of typing intricate command lines.

Follow the simple steps below to show hidden files with this 1-click-fix software.

Step 1. DOWNLOAD EaseUS Tools M for Free.

Step 2. Start EaseUS Tools M, choose 'File Showing' on the left pane. Next, choose the target drive for scanning.

Step 3. After the operation completes, click the View button to check the hidden files.

Fix 3. Using EaseUS Data Recovery Software

If neither of the above two ways files to unhide files in the folder, or if the virus deletes the files, you still have the last chance to fix files not showing up in folder and recover missing files by using a professional hard drive recovery software – EaseUS Data Recovery Wizard. This capable program can search and retrieve data lost/hidden in all situations.

Except for recovering deleted files, EaseUS data recovery program also does well in recovering files from emptied recycle bin, formatted/damaged hard drive/USB/Pen drive/SD card, lost partition, RAW partition, etc. Now, follow the steps below to recover files not showing up in folders.

Step 1. Select a location and start scanning.

Launch EaseUS Data Recovery Wizard, hover on the partition where you lost data, then click 'Scan'.

Step 2. Preview and select the files.

Excel Download Not Showing Correctly On A Macbook Pro

Wait until the scanning completes. If you need to double-click the item to preview the file, then select the data you attempt to recover.

Step 3. Recover lost data.

Click 'Recover', choose a location to save the recovered data, then click 'OK'. You should store the data in another place instead of the original one.

Other Quick Fixes for Files Not Showing in Folder Windows 10

As said before, files not showing up in folder or Windows Explorer not showing folders may be caused by Windows 10 update. If so, you can try tips below to troubleshoot.

1. Check for missing files and folders manually if they are moved to a different folder because of Windows 10 update. Go to This PC > Local Disk (C) > Users > User Name > Documents or This PC > Local Disk (C) > Users > Public.

2. Switch to your old user account if a new account is created for you per default by Windows 10.

3. Turn off Fast Startup in Power Options.

4. Set the folder to hidden and read-only temporarily and then cancel the setup.

Excel Download Not Showing Correctly On A Mac Computer

5. Check your hard drive to see if the files not showing problem is caused by HDD corruption.