+ Reply to Thread
Results 1 to 4 of 4

Excel Option setting does not go with file, right?

  1. #1
    Registered User
    Join Date
    05-12-2010
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2007
    Posts
    11

    Angry Excel Option setting does not go with file, right?

    A dumb question here, whether any setting up in the Option cannot go with the file. If yes, how we can make sure other user can open the file with the same set up?

    Recently, one workbook used in my team crashed after entering the data. After searched web, we found below solution. It solved my problem. But after I made below configuration change, I found this change only stayed in my computer. Others still had the problem.

    Click on File --> Options --> Advanced.
    2.In the Editing Options section, clear the checkbox for Automatically Flash Fill.
    3.Click on the General tab.
    4.Clear Show Quick Analysis options on selection.

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,725

    Re: Excel Option setting does not go with file, right?

    If it's company's internal network, have your IT team set up Group policy for Excel options through AD.
    https://getadmx.com/?Category=Office2016

    Edit: If it's a file that lives on network drive. You could have small piece of code on workbook open event.
    Please Login or Register  to view this content.
    And turn it back to "True", when needed (say before workbook close event).
    Last edited by CK76; 01-17-2019 at 10:50 AM.

  3. #3
    Registered User
    Join Date
    05-12-2010
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2007
    Posts
    11

    Re: Excel Option setting does not go with file, right?

    Thanks! It works

  4. #4
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,725

    Re: Excel Option setting does not go with file, right?

    You are welcome

    If this solved your issue, please mark the thread as solved by using thread tools found at top of your initial post.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Folder option setting
    By nerdzkilla in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-27-2018, 08:14 AM
  2. Option to add or don't add Header (row 1 to 9) in the Excel file
    By haitran in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-07-2018, 12:12 PM
  3. Macro Required for attaching a file through Browse option in excel file
    By vikash200418 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-18-2015, 12:38 AM
  4. Option setting mysteriously changes
    By DanBlum in forum Excel General
    Replies: 2
    Last Post: 07-08-2011, 03:29 AM
  5. File associate setting in Excel
    By jim28 in forum Excel General
    Replies: 4
    Last Post: 06-20-2006, 10:30 PM
  6. Setting an option control
    By Patrick Simonds in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-03-2006, 10:30 PM
  7. [SOLVED] Setting an Essbase Option using code
    By Nigel in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-29-2005, 01:35 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1