This article is designed to help with troubleshooting common issues with Pigment’s Connector for Excel and to share the known limitations with the connector. Please see this article for an overview and how to install the connector.
Table of contents
There are fewer rows or columns being pulled to (Sheet name) compared to the previous data pull. Some data on the sides of the pivot might be lost if you proceed. Error message explained.
When you are pulling in data from Pigment and the number or rows or columns is smaller, you will receive the following error. “There are fewer rows or columns being pulled to (Sheet name) compared to the previous data pull.
Some data on the sides of the pivot might be lost if you proceed.” The pivot describes the rows and columns that are being imported in from Pigment. When the number of rows is smaller, data located in the outside rows will be lost. For example, if you had 15 rows of data and your new pull now had 13 rows of data, any side calculations or notes in the last 2 rows will be deleted. This also applies if you have less columns.
Here is an example where there is less data in both rows and columns. Notice the last row and last column data that is outside the pivot. It doesn’t matter which item is removed, the last columns and rows will always be the ones removed.
What is the Pigment Connector for Excel’s pivot?
| The pivot describes the rows and columns that are being imported in from Pigment. You can easily highlight it in Excel, type in cmd/ctrl + G to open the Go to screen, from there enter pigment_data to see the area known as the Pivot. You can also use pigment_metadata to highlight the meta data about your connection. | 
|
Why can’t I see my page selectors?
| When viewing the All connections screen, you will not see any individual page selectors. You must have an individual connection open on a page to see the Page selectors. Click the back button located in the top left of the Pigment connector screen. | 
|
Deleting of Sheets with active connection
If a Sheet with an established connection is deleted, the following message will appear “The Sheet could not be found in the Excel document, it may have been deleted”. You can delete the connection or you can click the … (ellipses) next to the connection to edit the connection. From there, you can select a new Sheet.
I have No options under Sheet when creating a connection.
If you see No options when trying to create or duplicate a connection, this is because there are no available Sheets to attach to. Each sheet within a workbook can only have one connection. If there are connections established on all sheets, you must create a new sheet before connecting.
I am not seeing Aggregators being pulled into my spreadsheet for Dimension or Transaction Lists.
This is a known limitation with the connector. We support data pulls with Metrics and Tables, but not with Dimension or Transaction Lists. Feel free to share your feedback with us either through your CSM or by submitting an Idea if this is an important need for you!