Do you know of any issues with ASPOSE.Cells and Pivot tables? We are using the Aspose.Cells dll version 4.5.0.3. We are having an issue that is giving us an error that says “The PivotTable field name is not valid. To create a PivotTable report, you must use data that is organized as a list with labeled columns. If you are changing the name of a PivotTable field, you must type a new name for the field.” It seems we see this error randomly throughout our environments, and we end up messing with our template and the error temporarily goes away.
Here’s what we are doing… We have a template where we put our columns with smart markers for the data. We then create a pivot table by selecting the columns and the smart markers. We set up our pivot table how we want and set it up so that the pivot table refreshes when the document is opened. We then get our datatables from the database, set the datasources and then use the process method. We then save the designer in Excel 2003 format. If we save the document to our desktop before opening it, then everything works correctly. If we open it from the browser we get the above error. The data does not change between the two scenarios; therefore we think ASPOSE is causing the problem.