Hi, I followed the instructions on this sheet but rather than updating an existing named sheet, TDA creates a second sheet with a suffix e.g.-FileName _1_2. See image attached. I have already confirmed that my settings are set NOT to add a sufix but it is still doing this. What I would like it to do is to update the data on the specified sheet and keep all the other tabs intact (since those are the report tabs that draw from the data). Instead, TDA is erasing adding a sheet. I tried toggling the replace existing file setting but that erases the whole file and simply replaces it with just the data sheet.
This problem is the same if I try and program this from the automation page using the select to file and specify a specific file and specific sheet (row and column). Again, my expectation would be for the data to update in that specific sheet and leave everything else in the file intact. Instead it is creating a secondary sheet. Or as mentioned before if I specify replace file it replaces the whole thing -including my report sheets.
Please help and thanks,
Antonio
Server Error in '/' Application.
Operation is not valid due to the current state of the object.
Operation is not valid due to the current state of the object.
**Description:**
An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
**Exception Details:** System.InvalidOperationException: Operation is not valid due to the current state of the object.
**Source Error:**
`
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.`
**Stack Trace:**
[InvalidOperationException: Operation is not valid due to the current state of the object.] System.Web.HttpValueCollection.FillFromString(String s, Boolean urlencoded, Encoding encoding) +4008959 System.Web.HttpUtility.ParseQueryString(String query, Encoding encoding) +213 Telligent.Evolution.Rest.Framework.Infrastructure.RestPluginHttpHandler.ProcessRequest(HttpContext context) +325 System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +625 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +270
``
Version Information:
Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.272
">Update_your_Excel_reports..._automatically.docx