I have created a Worksheet where I have to change the values based on the parameter provided by the User. Basically, values for the various columns should change if I change the date using the parameter. On local machine parameter for the date is in Calender format (shown in image1) but when I publish the workbook to the server same parameter is getting converted to a textbox (image 2). What can I do to resolve this issue?
PS: I can't upload the workbook as it contains client sensitive data
Well it is not possible to load the original data, is it possible to share a sample workbook. Please review this article about why it is so helpful to supply some sample data - Packaged workbooks: when, why, how