We are using Prophix cloud version and Excel 2016. From experience, I know you can’t copy and paste from Excel 2016 to Prophix Cloud in either Ad Hoc or a Template. However, I was wondering if you could copy from Excel 365 and past to Prophix Cloud? Or will that not work either?
We could copy from Excel and Paste into Prophix when we used the on-prem version of Prophix.
Looking for some insight.
Thanks!
Hi Tara,
Copy and paste does work from excel to Prophix. Couple of things to keep in mind:
- You are using keyboard shortcuts (Windows commands - Ctrl+C for copy, Ctrl+V for paste)
- You are only doing so for the values a.k.a. numbers. That is, you are not highlighting / selecting non-value cells (viz. headers, dimension member titles, etc.) in Excel and are only pasting values (i.e. not over dimension members) in Prophix.
Cheers,
Navin
2 Likes