Shared setting for excel for users sharing a computer

to use excell i must make a lot of changes to excell defaukts, visuall basic allows, trusted docs, etc, i want to make these setting to apply to every user that loggs into the mac hine. How can i do this?

thanks in advance

April 30th, 2015 6:39am

Hi,

My understanding is that you want to create an identical Excel template/custom setting for every user profile in the same pc. Is it correct? If yes, we might to the two steps:

One: Save the custom workbook as a template (XX.xltx)

https://support.office.com/en-nz/article/Save-a-workbook-or-worksheet-as-a-template-58c6625a-2c0b-4446-9689-ad8baec39e1e

Two:  Distribute the XLTX file to the Excel XLStart folder. It's usually located here:

C:\Documents and Settings\<username>\Application Data\Microsoft\Excel\XLSTART

or here:

C:\Program Files\Microsoft Office\OFFICE14\XLSTART

https://support.office.com/en-sg/article/Customize-how-Excel-starts-6509b9af-2cc8-4fb6-9ef5-cf5f1d292c19

If I misunderstood something, please feel free let me know.

Regards,

George Zhao
TechNet Community Support

Free Windows Admin Tool Kit Click here and download it now
May 1st, 2015 12:48am

I think i mighthave not explained my self well. I set trusted documets visual basic acceptances and other excell defaults. that are not document related, but rater relaated to she setting of excel it self. These i want to duplicate for any user that loges into the computer. 

Thank you

May 1st, 2015 1:18pm

Sorry to bother you but have you looked at my response to shared settings?
Free Windows Admin Tool Kit Click here and download it now
May 6th, 2015 8:44am

Hi,

Sorry for reply delay, do you mind explaining your request more detailed about >>I set trusted documets visual basic acceptances and other excell defaults.<<?

Thanks,

George Zhao
TechNet Community Support

May 7th, 2015 8:57am

Thanks George here is a link to exactly what I am trying to do  https://mega.co.nz/#!axcBCZrL!omwtY4tQMRONTHfMZLG6UiUBhRx3mmWw3a4jcKW2Flk

..Ira

Free Windows Admin Tool Kit Click here and download it now
May 8th, 2015 2:23pm

OK, I see. My understanding is that you want to set these options by default for the machine. I suggest we use Office ADMX template via Group policy.

Download ADMX

More reference:

https://technet.microsoft.com/en-us/library/cc178992.aspx?f=255&MSPPError=-2147217396

Regards,

George Zhao
TechNet Community Support

May 10th, 2015 9:37pm

Thank you
Free Windows Admin Tool Kit Click here and download it now
May 20th, 2015 7:04am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics