Microsoft Excel 2011 On Mac Not Opening Csv Correctly

  1. Microsoft Excel 2011 On Mac Not Opening Csv Correctly Download
  2. Microsoft Excel 2011 On Mac Not Opening Csv Correctly List
  3. Microsoft Excel 2011 On Mac Not Opening Csv Correctly Pdf

See how to convert CSV to Excel correctly when the data contains different delimiters, dates or leading spaces. How to open a CSV file in Excel and import multiple CSV files in a single workbook in Excel. Mar 19, 2020  Excel not Open Correctly Hello. When I open Excel 2007 Filled with My Work / Data, Message Shown as 'THERE was a sending the Command to the Program'. But I Open new Excel Sheet from Start menu It's Open Correctly, How to Resole The Problem? Please look into C:UsersUserNameAppDataRoamingMicrosoftExcel (replace user name with your. Step 2: Remove your Excel preferences. Quit all Microsoft Office for Mac applications. On the Go menu, click Home. Open Library. Note The Library folder is hidden in Mac OS X Lion. To display this folder, hold down the OPTION key while you click the Go menu. Open Preferences. Drag com.microsoft.Excel.plist to the desktop. Apr 21, 2017  Trouble With Opening CSV Files With Excel? The Comma and Semicolon Issue in Excel Due to Regional Settings for Europe. When opening standard CSV (Comma Separated Values) files in Excel you may find that Excel did not recognize the fields and simply displays all data in the first column. The problem is. Excel not responding, hangs, freezes or stops working. And some features may not work properly when you open the files in Excel. If this occurs, test the features in new files outside the third-party application. If the features work correctly, you should make sure that the third party is aware of the issue. Microsoft does not recommend. Apr 24, 2012 though it can easily be found by going to HomeLibraryPreferences. In the same Preferences directory look for Microsoft Directory. Throw away to trash anything associated with Excel. Now restart Excel should now open. If not report back here for someone to help troubleshoot further.

-->

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 double-select an icon or file name for a Microsoft Excel workbook, Excel starts, then displays a blank screen where you expect the file content to appear.

Resolution

To resolve this problem, try the following methods, as appropriate, in the given order.

Method 1: Ignore DDE

This problem may occur if the Ignore other applications that use Dynamic Data Exchange (DDE) check box in Excel options is selected.

When you double-select an Excel workbook in Windows Explorer, a dynamic data exchange (DDE) message is sent to Excel. This message instructs Excel to open the workbook that you double-selected.

Opening

If you select the 'Ignore' option, Excel ignores DDE messages that are sent to it by other programs. Therefore, the DDE message that is sent to Excel by Windows Explorer is ignored, and Excel does not open the workbook that you double-selected.

To correct this setting, follow these steps:

Note

This step can be skipped for Excel 2019 and Excel O365

  1. In the upper-left corner of the Excel window, select File, then Options.
  2. On the left side of the Options window, select Advanced to open the Advanced window.
  3. In the Advanced window, scroll down to the General section.
  4. Clear the Ignore other applications that use Dynamic Data Exchange (DDE) check box, then select the OK button at the bottom of the window.

Note

For more information about how to turn off DDE, see 'An error occurred when sending commands to the program' in Excel

If these steps do not resolve the problem, continue to Method 2.

Method 2: Repair User Experience Virtualization (UE-V)

If you are running Update User Experience Virtualization (UE-V), install Hotfix 2927019. To do this, see the following Microsoft Knowledge Base article:

2927019 - Hotfix Package 1 for Microsoft User Experience Virtualization 2.0

If you are not sure whether you are running UE-V, examine the program list in the Programs and Features item in Control Panel. An entry for 'Company Settings Center' indicates that you are running UE-V.

Microsoft excel 2011 on mac not opening csv correctly pdf

If these steps do not resolve the problem, continue to Method 3.

Method 3: Reset file associations

To check whether the file associations in the system are performing correctly, reset the Excel file associations to their default settings. To do this, follow the steps for your operating system.

Windows 8.1/10

  1. Copy the file that is opening incorrectly, to your desktop.
  2. Right-click the file, and choose Properties
  3. On the General tab, next to Type of file, the type of file will be indicated within parenthesis. For example, (.docx), (.pdf), or (.csv).

The Opens with shows you which app it is currently associated with.

To open this type of file in a different app:

  1. Select Change.
  2. Select More apps.
  3. Select the desired app, then select the checkbox to Always use this app.
  4. Select the OK button.

Windows 8

  1. On the Start screen, type Control Panel.
  2. Select or tap Control Panel.
  3. Select Default Programs, then select Set your default programs.
  4. Select Excel, then select Choose default for this program.
  5. On the Set Program Associations screen, select Select All, then select Save.

Windows 7

  1. Select Start, then select Control Panel.
  2. Select Default Programs.
  3. Select Associate a file type or protocol with a specific program.
  4. Select Microsoft Excel Worksheet, then select change program.
  5. Under Recommended Programs, select Microsoft Excel.
  6. If Excel does not appear in this list, select Browse, locate the Excel installation folder, select Excel.exe, then select Excel.

If these steps do not resolve the problem, continue to Method 4.

Method 4: Repair Office

Try to repair your Office programs. To do this, follow the steps for your installation type and operating system.

For an Office 365 or Office 2019 Click-to-Run installation

Windows 10
  1. On the Start screen, type Settings.
  2. Select or tap Settings.
  3. In the Settings window, select or tap Apps.
  4. In the Apps & features window, scroll down to your Office program and select or tap it.
  5. Select or tap the Modify button.
  6. In the How would you like to repair your Office programs window, select or tap the Online Repair radio button, then select or tap the Repair button.
Windows 8
  1. On the Start screen, type Control Panel.
  2. Select or tap Control Panel.
  3. Under Programs, select or tap Uninstall a program.
  4. Select or tap Microsoft Office 365, then select or tap Change.
  5. Select or tap Online Repair, then select or tap Repair. You may have to restart your computer after the repair process is finished.
Windows 7

  1. Select Start, then select Control Panel.

  2. Double-select Programs and Features.

  3. Select Microsoft Office 365, then select Change.

  4. Select Online Repair, then select Repair.

Note

You may have to restart your computer after the repair process is complete.

Microsoft Excel 2011 On Mac Not Opening Csv Correctly Download

For an Office 2013, Office 2010, or Office 2007 installation

To repair Office 2013, Office 2010, or Office 2007, follow the steps in the following Office website topic:

If these steps do not resolve the problem, continue to Method 5.

Method 5: Turn off add-ins

Excel and COM add-in programs can also cause this problem. These two kinds of add-ins are located in different folders. For testing, disable and isolate the conflict by turning off each add-in one at a time. To do this, follow these steps:

.Color handle: Each color handle underneath the live preview rectangle in the Format Shape dialog represents a color in your gradient fill. This option is not available for the Linear and Path style gradients.The Color and Transparency section lets you add multiple colors and shades of color to your shape’s gradient fill. Microsoft word and excel for mac.

  1. On the File menu, select Options, then select Add-Ins.
  2. In the Manage list at the bottom of the screen, select COM Add-Ins item, then select Go.
  3. Clear one of the add-ins in the list, then select OK.
  4. Restart Excel by double-selecting the icon or file name for the workbook that you are trying to open.
  5. If the problem persists, repeat steps 1-4, except select a different add-in in step 3.
  6. If the problem persists after you clear all the COM Add-ins, repeat steps 1-4, except select Excel Add-Ins in step 2, then try each of the Excel add-ins one at a time in step 3.

If Excel loads the file, the add-in you last turned off is causing the problem. If this is the case, we recommend that you visit the manufacturer's website for the add-in to learn whether an updated version of the add-in is available. If a newer version of the add-in is not available, or if you don't have to use the add-in, you can leave it turned off.

If Excel does not open the file after you turn off all the add-ins, the problem has a different cause.

If these steps do not resolve the problem, continue to Method 6.

Method 6: Disable hardware acceleration

To work around this problem, disable hardware acceleration until a fix is released by your video card manufacturer. Make sure to check regularly for updates to your video card driver.

To disable hardware acceleration, follow these steps:

  1. Start any Office 2013, 2016, 2019, or O365 program.

  2. On the File tab, select Options.

  3. In the Options dialog box, select Advanced.

  4. In the list of available options, select the Disable hardware graphics acceleration check box.

    The following screen shot shows this option in Excel.

  5. Select the OK button.

Note

For more information about hardware acceleration, see the following Microsoft Knowledge Base article:

2768648 - Performance and display issues in Office 2013 client applications

Microsoft Excel 2011 On Mac Not Opening Csv Correctly List

Method 7: Minimizing and maximizing the window

Minimizing and then maximizing the window can sometimes refresh the Excel page and cause any hidden data to appear.

  1. Select the minimize button in the top-right corner of the Excel sheet.
  2. In the task tray, right-click Excel and select your spreadsheet. (Or double click the Excel icon.)

When your sheet is maximized, your data may appear.

Method 8: Check for hidden sheets

An Excel sheet may have inadvertently been saved as a hidden document. To find out:

  1. Go to the View tab.
  2. Select Unhide.
  3. Choose a workbook from the list.
  4. Select OK.

If you still experience this problem after you try all these methods, contact Microsoft Support for additional troubleshooting help.

-->

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 try to start Microsoft Excel for Mac, you receive the following error message:

Microsoft Excel has encountered a problem and needs to close. We are sorry for the inconvenience.

Cause

This error may occur if one of the following conditions is true:

  • The Excel preferences are corrupted.
  • Programs that are running in the background are interfering with Excel for Mac.
  • Application files are corrupted.
  • A user account profile is corrupted.

Resolution

To resolve this issue, try the following methods, in order, until the issue is resolved.

Microsoft Excel 2011 On Mac Not Opening Csv Correctly Pdf

Method 1

Step 1: Quit all programs

You must quit all programs before you continue. To quit an application, select the application on the toolbar (top), and then select Quit. If you cannot quit an application or do not know how, hold down the Command and Option keys, and then press Esc on your keyboard. Select the application in the 'Force Quit Application' window, and then select Force Quit. Click Force Quit to quit the application.

When you are finished, click the red button in the upper-left corner and go to step 2.

Step 2: Remove your Excel preferences

  1. Quit all Microsoft Office for Mac applications.

  2. On the Go menu, click Home.

  3. Open Library. Note The Library folder is hidden in Mac OS X Lion. To display this folder, hold down the OPTION key while you click the Go menu.

  4. Open Preferences.

  5. Drag com.microsoft.Excel.plist to the desktop. If you cannot locate the file, Excel is using the default preferences. Go to step 7.

  6. Open Excel, and check whether the problem still occurs. If the problem still occurs, quit Excel, restore the file to its original location, and go to the next step. If the problem is resolved, drag com.microsoft.Excel.plist to the Trash.

  7. Quit all Office for Mac applications.

  8. On the Go menu, click Home.

  9. Open Library.

    Note

    The Library folder is hidden in Mac OS X Lion. To display this folder, hold down the OPTION key while you click the Go menu.

  10. Open Preferences.

  11. Open Microsoft, and then drag com.microsoft.Excel.prefs.plist to the desktop. If you cannot locate the file, Excel is using the default preferences. Go to step 13.

  12. Open Excel, and check whether the problem still occurs. If the problem still occurs, quit Excel, restore the file to its original location, and go to Method 2. If the problem is resolved, drag com.microsoft.Excel,prefs.plist to the Trash.

Method 2

Use the 'Repair Disk Permissions' option

You can use the Repair Disk Permissions option to troubleshoot permissions problems in Mac OS X 10.2 or later versions. To use the Repair Disk Permissions option, follow these steps:

  1. On the Go menu, click Utilities.
  2. Start the Disk Utility program.
  3. Click the primary hard disk drive for your computer.
  4. Click the First Aid tab.
  5. Click Repair Disk Permissions.

Note

The Disk Utility program only repairs software that is installed by Apple. This utility also repairs folders, such as the Applications folder. However, this utility does not repair software that is in your home folder.

Open Excel and check if the issue is resolved. If it is not, continue to Method 3.

Method 3

Create and use a new user account

To create a new user account, use the following procedure.

Note

You many have to reinstall Office if you log on with a new account.

  1. Click the Apple icon, and then click System Preferences.

  2. Click Accounts.

  3. Click the plus sign ('+') in the lower-left corner to open the new account window.

    Note

    If you are not the Administrator of the computer, click Click the lock to make changes. Log on by using your Administrator user name and password, and then click OK.

  4. Type the word Test for the user name, and leave the password box blank. Click Create Account. When you receive a warning, click OK.

  5. Click to select Allow User to Administer this computer. (If this option is not available, just go to the next step).

  6. Click the Apple icon, and then click Log Out name.

  7. Log on with your Test account.

Open Excel and check if the issue is resolved. If you can save when you use a new user account, contact Apple support to troubleshoot your existing account. If you do not want to keep your existing account, you can rename the 'Test' account that you create in the following procedure, and continue to use that account. If it is not, continue to Method 4.

Method 4

Remove and then reinstall Office

For information about how to remove and then reinstall Office, see the following article:

Third-party disclaimer information

The third-party products that this article discusses are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, about the performance or reliability of these products.

The information and the solution in this document represent the current view of Microsoft Corporation on these issues as of the date of publication. This solution is available through Microsoft or through a third-party provider. Microsoft does not specifically recommend any third-party provider or third-party solution that this article might describe. There might also be other third-party providers or third-party solutions that this article does not describe. Because Microsoft must respond to changing market conditions, this information should not be interpreted to be a commitment by Microsoft. Microsoft cannot guarantee or endorse the accuracy of any information or of any solution that is presented by Microsoft or by any mentioned third-party provider.

Comments are closed.