Question

In: Computer Science

Is there a way to limit the # of times an Excel file can be opened?...

Is there a way to limit the # of times an Excel file can be opened? The solution would also require that the Excel file could not be copied to another location to bypass the counter.

Solutions

Expert Solution

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 Office\root\xx\XLSTART

    • For Office365 or 2019 64 bit:

      C:\Program Files\Microsoft Office\root\xx\XLSTART

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

    Also try the following:

    • %appdata%\Microsoft\excel\XLSTART
    • C:\Users\UserName\AppData\Roaming\Microsoft\excel\XLSTART
  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.

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.

Note

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

Press the ESCAPE key

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 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:

  • 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:

  • Use startup folders in Excel
  • Description of the startup switches for Excel

Related Solutions

Can you think of a way that Excel can be used unethically and give an example?...
Can you think of a way that Excel can be used unethically and give an example? Your answer must be a minimum of 2 paragraphs, no spelling errors, and complete sentences.
Please provide an excel file that can answer questions similiar to this one by chaning the...
Please provide an excel file that can answer questions similiar to this one by chaning the data and inputing new data 1.You sell short 100 shares of the GTY stock at $80 per share. Assume your broker requires an initial margin of 40% and a maintenance margin of 25%. 1)If the stock price drops to $70, what is the percentage margin? Initial total stock value: $80(100)=$8,000 If the stock price drops to $70, Total stock value: $70(100)=$7,000 Required margin deposit...
Can you send the excel file if I provide an email address? This is a question...
Can you send the excel file if I provide an email address? This is a question on managerial decision making with excel spreadsheet. A step wise how to solve this will be appreciated for homework and not any exam. A model in excel will really help. John’s Truck John owns John’s Truck Rental, which is currently for sale for $650,000. He would like you to develop a five-year spreadsheet model to assist buyers in their evaluation of the company. The...
Answer the following problems in an Excel file. Please upload only one Excel file with all...
Answer the following problems in an Excel file. Please upload only one Excel file with all of your answers, including #3 (which requires an explanation rather than a calculation). All problems must be solved using the PV and FV functions in Excel. If I deposit $8,000 in a bank account that pays interest of 1.5%, compounded annually, how much will I have in the account after 10 years? If I deposit $8,000 in a bank account that pays simple interest...
Please create an Excel file with the calculated answers to the questions to the Excel homework...
Please create an Excel file with the calculated answers to the questions to the Excel homework for this week. The questions are listed in the attached PDF file.   Please also go over the Excel file attached to this assignment in order to familiarize yourself with the different ways Excel can be used to solve Time Value of Money problems when multiple cash flows are involved. There are three worksheets in the Excel file. This Excel file with examples is just...
I need this in an excel file with formulas please: 1) Use an Excel spreadsheet to...
I need this in an excel file with formulas please: 1) Use an Excel spreadsheet to solve problem #31 (the PUTZ, Inc. project) for Chapter 10 in the textbook. 2) Conduct a sensitivity analysis that focuses on the sales price by increasing the price by 10% above the best estimate, and then by decreasing the price by 10% below the best estimate. 3) You must provide one spreadsheet for each of the three situations—the base case estimate, the best case,...
Describe how to open a file in Excel? What is the difference between opening a file...
Describe how to open a file in Excel? What is the difference between opening a file and creating a new file in Excel?
A file filter reads an input file, transforms it in some way, and writes the results...
A file filter reads an input file, transforms it in some way, and writes the results to an output file. Write an abstract file filter class that defines a pure virtual function for transforming a character. Create one subclass of your file filter class that performs encryption, another that transforms a file to all uppercase, and another that creates an unchanged copy of the original file. The class should have a member function void doFilter(ifstream &in, ofstream &out) that is...
PLEASE UPLOAD EXCEL FILE OR A SCREENSHOT SHOWING FORMULAS Must be submitted in excel with any...
PLEASE UPLOAD EXCEL FILE OR A SCREENSHOT SHOWING FORMULAS Must be submitted in excel with any math done with formulas within cells. The Jackpots Dreams Cards Company is a card manufacturer. All direct materials and conversion costs are applied to all of Proball Trading Cards’ products at an even rate throughout the manufacturing process. For August, the beginning work in process inventory for the Finishing Department was 9,600 units that averaged 65 percent complete. Ending work in process inventory was...
Utilizing the excel examples in Blackboard create and excel file that answers NPV, IRR, Payback for...
Utilizing the excel examples in Blackboard create and excel file that answers NPV, IRR, Payback for the following situation. Initial investment $1000, annual cash flow of $300 Program life for 8 years Hurdle rate of 5%
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT