Problem to save file
Hi,
I did choose
to open the Excel file, but when saving it, I then have got
Why?
I did choose
to open the Excel file, but when saving it, I then have got
Why?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Open the source file you are trying to work with and save as an xltx or xltm (if you need the macros). This should be saved to a shared location so other can get it with ease.
Once this is saved you can access it by going to File | New | Share | select the newly created template file.
Once you have completed the excel file and you want to save it all you have to do is File | Save or Save as | the save prompt window will appear and you can name it.
Note that you will need to add a trusted location for the shared location. To do this you will need to go to File | Options | Trust Center | click on Trust Center Setting | Select Trusted Location | Add the trusted location to excel.
The template I made is called Please Enter
Once this is completed, tested and validated you can push the trust center setting out via GPO's.
Once this is saved you can access it by going to File | New | Share | select the newly created template file.
Once you have completed the excel file and you want to save it all you have to do is File | Save or Save as | the save prompt window will appear and you can name it.
Note that you will need to add a trusted location for the shared location. To do this you will need to go to File | Options | Trust Center | click on Trust Center Setting | Select Trusted Location | Add the trusted location to excel.
The template I made is called Please Enter
Once this is completed, tested and validated you can push the trust center setting out via GPO's.
ASKER
I've added current path to Trusted Location of Excel file but how to save current file as xltx or xltm file? Can you please show with more detailed steps to this?
You need to open the original xlsm file and save as an xltx or xltm file.
File | Save As | Under the file type click the drop-down and select one of the file type xltx or xltm.
2018-03-16_8-29-48.png
File | Save As | Under the file type click the drop-down and select one of the file type xltx or xltm.
2018-03-16_8-29-48.png
ASKER
I save Excel file as xltm file but then I still have got this
Are you opening the directly from File | Open? You have to go to File | New | Share | select your new template file.
ASKER
Thanks a lot.
Do I need to every time to use
File | New | Share | Select file
to open the file?
Do I need to every time to use
File | New | Share | Select file
to open the file?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
The current file is now existing in Sharepoint, and what to further choose below, to select the file?
What version of sharepoint
ASKER
It should be Sharepoint 2013. Where can we see Sharepoint's version below?
I will see if I can find something tomorrow. The question you asked never referenced sharepoint. This is really a completely different question. You left a very important piece of information when you asked about sharepoint.
My solution focused on Excel native Workspace for templates. I do not have knowledge of SharePoint and how to implement, but I did find a link that may help. https://support.office.com/en-us/article/add-multiple-office-templates-to-a-document-library-cde94e90-a1ba-4b94-a187-600ed68562bb
ASKER
Within the same Sharepoint, I have no problem to other Excel files and also in the past, I didn't have same issue to the same Excel file. What can be the reason to current problem?
I am not sure then.
I sorry.
I sorry.
ASKER