Great to see this new functionality! 2 questions:
- Is there a way to preserve formatting in Excel (i.e., to refresh data in a report)
- I cannot see an option to “push” data, only to pull. What am I missing?
Thanks!
Best answer by Keiran
View original
Excel Connector questions
- Just Arrived
- 0 replies
Userlevel 5
+8
- Community Manager
- 44 replies
-
8 August 2023
- Answer
Hi Mitch,
I hope you’re well!
- Yes, the formatting should be saved if you set it up in excel first, then pull the data, then save. You should be able to refresh your data.
- Push is not currently available but it is a candidate on the product roadmap. As usual I’d recommend you raise an idea here explaining the case and the priority so the Product Managers can review - this will help them to prioritise. You can do this here: Product ideas | Community (gopigment.com)
I hope this helps!
Userlevel 1
+2
- Newly Minted Pigmenteer
- 5 replies
-
11 October 2023
I see that I can keep formatting in excel in terms of borders, colors, etc. but every time the data is pulled the number formatting for cells is replaced. Is there a way to ensure that number formatting is not overwritten every time data is pulled via the connector?
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.