Forum Discussion
Get filename column back
in the process of setting up my template file, i believe i accidently deleted the column that had the filename of the dataset (excel) that im building it on. Is there a way to 1.) add a column with ...
hi sir and thank you for your response.
1.) i created a query that its current value is "https://TEST.sharepoint.com/sites/sharepoint/Manpower%20Reports"
so when i open my template, it asked me for a File Location dialog box. I paste in the location like this:
"https://TEST.sharepoint.com/sites/sharepoint/Manpower%20Reports/TEST.xlsx"
it then loads up the file as it should. I just need to get label at the top left to display the File name minus the .xlsx
hope this helps....