Return to site

How Many Instances Of Excel 2016 For Mac Can Youhave Open

broken image


-->

Note

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

Summary

This article describes how to prevent files from automatically opening when you start Microsoft Excel.

I have a very unique problem that I am hoping someone can help me with. I have a user who has Microsoft Office 2010 Service Pack 2 installed on her computer. When she opens Excel, the screen flashes multiple times and if you look at the taskbar you can see multiple instances of Excel trying to open in succession. What are the benefits of running multiple instances of Excel?-If you have 32-bit Excel, each instance can use up to 3 GB memory. If you have a powerful computer, very heavy files, and 32-bit Excel, each instance of Excel can use 3 GB. 2 instances of Excel.exe, you could say that the total memory Excel could use triples. 32-bit versions of Excel 2016 can take advantage of the Large Address Aware (LAA) functionality after installation of the May 3, 2016, update for Outlook 2013 (KB3115031), build 16.0.6868.2060 for O365 Current Channel subscribers. This change lets 32-bit installations of Excel 2016 consume double the memory when users work on a 64-bit Windows OS. Jun 07, 2018.

More information

When you start Excel, all the files that are located in the XLStart folder are automatically opened. This behavior occurs regardless of the kind of file. Additionally, if you specified an alternative startup folder for Excel, every file in that folder is also automatically opened.To remove an alternative startup folder:

  1. Select the File menu and then select Options.
  2. Select the Advanced tab and then locate the General section.
  3. Clear the box next to 'At startup, open all files in:'.

Excel might stop responding or take longer to start if either of the following conditions is true:

  • The files in either startup folder aren't valid Excel workbooks or worksheets.
  • The files are stored on a network drive that has a slow network connection.

How to prevent files from automatically opening in Excel

Use one of the following methods to prevent files from automatically opening when you start Excel.

Remove files from the XLStart folder and the alternative startup folders

To remove files from the XLStart folder and the alternative startup folders, follow these steps:

  1. Select Start, and then select Run.

  2. In the Open box, type one of the following and press Enter:

    • For Office365 or 2019 32 bit:

      C:Program Files (x86)Microsoft OfficerootxxXLSTART

    • For Office365 or 2019 64 bit:

      C:Program FilesMicrosoft OfficerootxxXLSTART

      Where 'xx' represents the version that you are using (for example, Office15, Office14, etc.).

    Also try the following:

    • %appdata%MicrosoftexcelXLSTART
    • C:UsersUserNameAppDataRoamingMicrosoftexcelXLSTART
  3. Delete any files in the XLStart folder or move them to another folder.

  4. Restart Excel.

Start Excel in safe mode

Note

This is only a temporary solution that will not fix the issue. To use this method, it must be done every time that you start Excel.

Another method for preventing files from automatically opening is to start Excel in safe mode. Starting Excel in safe mode prevents all Excel add-ins, toolbar customizations, and startup folders from loading when the program is started.

There are two ways to start Excel in safe mode: the CTRL key and command-line switches.

Using the CTRL key

To start Excel in safe mode, hold down the CTRL key while you start Excel. You will receive the following message: Excel has detected that you are holding down the CTRL key. Do you want to start Excel in Safe mode? Select Yes to start in safe mode.

You can then delete files from the alternative startup location as described earlier.

Use Command-line switches

In all versions of Excel, you can use a command-line switch to start Excel in safe mode.Both the /safe switch and the /automation switch can be used for this purpose.

Note

The /safe switch starts Excel in safe mode. The /automation switch disables all automatically opened files and auto-run macros.

Opf to pdf online. To use a command-line switch to start Excel, follow these steps:

  1. Select Start, and then select Run.

  2. In the Open box, type either of the following lines (but not both):

    excel.exe /safe

    excel.exe /automation

  3. Select OK.

How Many Instances Of Excel 2016 For Mac Can You Have Open Space

Note

If Microsoft Windows Installer starts when you use one of these command-lines switches, clickCancel to finish starting Excel.

Press the ESCAPE key

Buying a number in craps. Note

Harrahs online casino pa. This is only a temporary solution that will not fix the issue. To use this method, it must be done every time that you start Excel.

Another method for preventing files from automatically opening is to press the ESCAPE key (but do not press and hold). When you press ESCAPE after the files start to open, Excel is prevented from opening additional files.

Using this method, you may receive one or both of the following messages:

How many instances of excel 2016 for mac can you have open windows
  • Would you like to cancel opening all files from your Alternate Startup File Location?
  • Would you like to cancel opening all files from your XLStart Location?

If you click Yes in either message, Excel starts without opening any additional files from the startup locations.

Note

Do not hold the ESCAPE key. If you do this, the messages will be closed before you can click Yes.

References

For more information about Excel startup folders, see the following Microsoft Knowledge Base articles:

Excel 2016 runs only under Windows 7, 8, and, of course, the new Windows 10 operating system. This means that if your PC is running the old Vista or XP versions of Windows, you must upgrade before you can successfully install and run Excel 2016.

How Many Instances Of Excel 2016 For Mac Can You Have Opening

Starting Excel from the Windows 10 Start menu

Windows 10 brings back the good old Start menu that many of you remember from much earlier Windows versions. The Windows 10 Start menu combines the straight menu from earlier days with the tile icons so prominent in Windows 8. To open this menu to launch Excel 2106, click the Windows icon on the taskbar or press the Windows key on your keyboard.

Then, click the All Apps button under the list of the Most Used applications in the menu and scroll down to Microsoft Office 2016 under the Ms in the list. Select the Expand button (with the caret pointing downward) to display your Office applications where you click Excel 2016.

You can pin an Excel 2016 button to the Windows 10 Start menu and/or its taskbar. This enables you to launch Excel simply by selecting this button. To pin a button, right-click the Excel 2016 menu item in the Start menu and then select the Pin to Start and/or Pin to Taskbar items in the displayed context menu.

How many instances of excel 2016 for mac can you have open windows
  • Would you like to cancel opening all files from your Alternate Startup File Location?
  • Would you like to cancel opening all files from your XLStart Location?

If you click Yes in either message, Excel starts without opening any additional files from the startup locations.

Note

Do not hold the ESCAPE key. If you do this, the messages will be closed before you can click Yes.

References

For more information about Excel startup folders, see the following Microsoft Knowledge Base articles:

Excel 2016 runs only under Windows 7, 8, and, of course, the new Windows 10 operating system. This means that if your PC is running the old Vista or XP versions of Windows, you must upgrade before you can successfully install and run Excel 2016.

How Many Instances Of Excel 2016 For Mac Can You Have Opening

Starting Excel from the Windows 10 Start menu

Windows 10 brings back the good old Start menu that many of you remember from much earlier Windows versions. The Windows 10 Start menu combines the straight menu from earlier days with the tile icons so prominent in Windows 8. To open this menu to launch Excel 2106, click the Windows icon on the taskbar or press the Windows key on your keyboard.

Then, click the All Apps button under the list of the Most Used applications in the menu and scroll down to Microsoft Office 2016 under the Ms in the list. Select the Expand button (with the caret pointing downward) to display your Office applications where you click Excel 2016.

You can pin an Excel 2016 button to the Windows 10 Start menu and/or its taskbar. This enables you to launch Excel simply by selecting this button. To pin a button, right-click the Excel 2016 menu item in the Start menu and then select the Pin to Start and/or Pin to Taskbar items in the displayed context menu.

Starting Excel from the Windows 10 Ask Me Anything text box

Instead of opening the Windows 10 Start menu and locating the Excel 2016 item there, you can launch the program by selecting this item from the Search the Web and Window text box. Simply type excel into the text box that appears to the immediate right of the Windows button on the taskbar and click Excel 2016 at the top of its result list.

How Many Instances Of Excel 2016 For Mac Can You Have Open House

If you want Cortana, the voice-activated online Windows assistant, to launch Excel 2016 for you, click the microphone icon in this text box (that is now called Ask Me Anything). When she displays the listening prompt, say 'Cortana, start Microsoft Excel 2016.'





broken image