Problem to save file

Hi,
I did choose
22i.png
to open the Excel file, but when saving it, I then have got
22j.png
Why?
LVL 12
HuaMin ChenProblem resolverAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

yo_beeDirector of Information TechnologyCommented:
XLSM is just an excel (XLSX) with embedded marcos.  You are opening a file from a share location and there is a lock on the file from the file server just like xlsx.  You need to save the template as an XLTM file and you should not need that custom prompt.  If the marco is strictly for the prompt to try an create a editable file you may not even need to save it as XLTM. You can get rid of the prompt and save it as an XLTX.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
HuaMin ChenProblem resolverAuthor Commented:
How to save the current .xlsm file as an XLTX file, in Excel 2016?
yo_beeDirector of Information TechnologyCommented:
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.  
img4.png
img5.png
img1.png
img2.png
The template I made is called Please Enter
img3.png

Once this is completed, tested and validated you can push the trust center setting out via GPO's.
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

HuaMin ChenProblem resolverAuthor Commented:
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?
yo_beeDirector of Information TechnologyCommented:
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-28-40.png
2018-03-16_8-29-15.png
2018-03-16_8-36-34.png
2018-03-16_8-31-57.png2018-03-16_8-29-48.png
HuaMin ChenProblem resolverAuthor Commented:
I save Excel file as xltm file but then I still have got this
22o.png
yo_beeDirector of Information TechnologyCommented:
Are you opening the directly  from File | Open? You have to go to File | New | Share | select your new template file.
HuaMin ChenProblem resolverAuthor Commented:
Thanks a lot.

Do I need to every time to use

File | New | Share | Select file

to open the file?
yo_beeDirector of Information TechnologyCommented:
For templates yes.
This holds true for Word and Powerpoint.  

What you are doing is using it as a template to start a brand new file.  Now if you need to edit the xltm file you need to do a File | Open | source file.  Once done editing you can do a save as or save to the file so others can start using the modified template.
HuaMin ChenProblem resolverAuthor Commented:
The current file is now existing in Sharepoint, and what to further choose below, to select the file?
22p.png
yo_beeDirector of Information TechnologyCommented:
What version of sharepoint
HuaMin ChenProblem resolverAuthor Commented:
It should be Sharepoint 2013. Where can we see Sharepoint's version below?
22q.png
yo_beeDirector of Information TechnologyCommented:
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.
yo_beeDirector of Information TechnologyCommented:
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
HuaMin ChenProblem resolverAuthor Commented:
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?
yo_beeDirector of Information TechnologyCommented:
I am not sure then.
I sorry.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
VBA

From novice to tech pro — start learning today.