@ i have an excel work book contains pivot table, i need to share it with one of my colleagues as the work book on our shared drive , so when i do share it gives me an error of unable to share or change tables to ranges but i need to keep pivot table
Oh, I see. Shared Workbooks have severe limitations, and one in particular is the inability to use tables and pivot tables. Unfortunately I haven't seen a decent workaround yet. Unless you and your colleagues use a newer version of Excel. In Excel365 there is a feature called Co-authoring, which is the replacement for Shared Workbooks. It works with tables and pivot tables well: support.microsoft.com/en-us/office/collaborate-on-excel-workbooks-at-the-same-time-with-co-authoring-7152aa8b-b791-414c-a3bb-3024e46fb104
Brilliant video 👍👍. Thank you very much
Hi 👋
Is there any solution to share an excel work sheet which has a tables or pivot tables
The link is here:
docs.google.com/spreadsheets/d/13sIA_sssQvn9feXYnMpxQgGOw9oH_z3j?rtpof=true&usp=drive_fs
@ unfortunately this link not replying to my question 🙋♂️
Sorry, it seems I didn't understand the question correctly. Can you specify the problem a bit?
@ i have an excel work book contains pivot table, i need to share it with one of my colleagues as the work book on our shared drive , so when i do share it gives me an error of unable to share or change tables to ranges but i need to keep pivot table
Oh, I see. Shared Workbooks have severe limitations, and one in particular is the inability to use tables and pivot tables. Unfortunately I haven't seen a decent workaround yet. Unless you and your colleagues use a newer version of Excel. In Excel365 there is a feature called Co-authoring, which is the replacement for Shared Workbooks. It works with tables and pivot tables well:
support.microsoft.com/en-us/office/collaborate-on-excel-workbooks-at-the-same-time-with-co-authoring-7152aa8b-b791-414c-a3bb-3024e46fb104