• Products
    • Sage Intelligence Reporting
      • Enrolment
    • Velixo
      • Enrolment
        • Velixo for Acumatica
        • Velixo for Sage Intacct
  • Services
    • Consulting
    • Training
    • Development
  • Support
    • Support Overview
    • Create Support Ticket
    • Book A Session
    • Knowledgebase
  • About
    • About Us
  • Contact
  • Products
    • Sage Intelligence Reporting
      • Enrolment
    • Velixo
      • Enrolment
        • Velixo for Acumatica
        • Velixo for Sage Intacct
  • Services
    • Consulting
    • Training
    • Development
  • Support
    • Support Overview
    • Create Support Ticket
    • Book A Session
    • Knowledgebase
  • About
    • About Us
  • Contact
Quick Support
Book Demo

How to automatically open a frequently used workbook

By admin on February 17, 2017April 19, 2019

If you start each day needing to use a frequently used workbook, e.g. daily sales report, to-do list, calendar, etc, then this tip is for you.  You can automatically open these workbooks, by simply adding the workbooks or a shortcut in the XLStart folder.  This is a specific folder that Microsoft® Excel® uses in which files have been saved that need to open every time the program starts.
Applies To: Microsoft Excel 2010, 2013 and 2016.
Place a workbook in the XLStart folder
The location of this folder is dependent on your version of Excel and Windows.  For example:
C:Users<Name>AppDataRoamingMicrosoftExcelXLSTART
The workbooks themselves can be saved in this folder or alternatively, you can create a shortcut to them.  To create a shortcut, right-click in the XLStart folder and select New > Shortcut, then browse to the required workbook.
You can locate the exact path to the XLStart folder in the Excel Trust Center.
How to locate the XLStart folder:
Select the File menu, and then select Excel Options.
Select Trust Center, and then under Microsoft® Excel® Trust Center, select Trust Center Settings.
Select Trusted Locations, and then verify the path to the XLStart folder in the list of trusted locations.
By placing a frequently used workbook in the XLStart folder, you will save time. Instead of opening multiple workbooks daily, the workbooks will automatically be opened when you start Excel.
The post How to automatically open a frequently used workbook appeared first on Sage Intelligence.

Powered by WPeMatico

Post navigation

How to extract the formula text in Excel
Conveniently remove blank item rows in your PivotTable reports

Recent Posts

  • Why Working In Excel Works
  • Alchemex Welcomes Velixo 6 For MYOB Advanced
  • Welcome to Velixo Reports Version 4.2
  • Part 3 of 3: Learn how to create a Management Pack in Sage 50cloud Intelligence
  • Part 3 of 3: Create and customize reports easily with the Financial Report Designer

Search

Contact Us

Phone: +61 2 9890 2339
Email: sales@alchemex.com.au
Address: PO Box 212, Deaken West, Canberra, Australia, 2600

Products

  • Intelligence Reporting
  • Velixo Reports

Services

  • Consulting
  • Training
  • Development

About

  • About Us
  • Partners
  • Blog

Support

  • New Ticket
  • Community (Coming Soon)
  • Knowledgebase

Phone: +61 2 9890 2339
Sales: sales@alchemex.com.au
Support: support@alchemex.com.au

Facebook-f Linkedin

© All rights reserved Alchemex Pty Ltd 2020

Made with ❤ by Unfazed Ltd