Announcements
Hi,
I am trying to import an excel file as a table in personal productivity environment. But I am getting the below error (screenshots for reference). Can anyone suggest how can we check the settings of importing table from ADMIN center ?
Thank you in advance
HI,
There are a lot of ways to do this process.
1) in excel first of all make the data A table, then click in any cell and you can see table design, then Export then Select SharePoint. etc....
2) I like to use Access to test all this because it connects easy. Import the excel spreadsheet into Access then export it from there to the SharePoint site. this is cleaner and easier in my view.
in the end you may have rights issues, but I have seen this a few times with just different versions and program compatibility.
Hi @JayMagness ,
Thanks for providing insight. Here I am trying to understand why we do not have rights in the personals productivity environment even though we have facility to directly import the data from Excel file. Therefore, the question has been asked how to check the rights of Personal Productivity Environment
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 427 Most Valuable Professional
11manish 201 Super User 2026 Season 2
MS.Ragavendar 128 Super User 2026 Season 2