Currently, this is what is happening. There is a network folder which has two files - a xlsm file that has several pivots and pivot charts in it. There is also a crtx template file in the same location,which
stores the chart template style. Now when users refresh the charts in the xlsm files, it gets a weird format and extra text in the chart.
Thats why when they press a button - then the charts in the existing xlsm file, get a stored template applied to them, to maintain the chart look as desired.
Problem - right now the code you see is below:
set wks = activesheet
templateLoc = "network\kkk\myChartTemplate.crtx"
is there is any way that I could put the template or embed the template directly inside the xlsm file itself (that has all the pivots and charts?)
-Instead of storing the crtx file separately and then applying template from it into the xlsm file?