Help

Some Users having an Excel error when exporting from Powerschool

Eggsolint
New Member

Some Users having an Excel error when exporting from Powerschool

I work in the I.T of a school district and we have been noticing this error message when some users export to an excel file.

 

"We found a problem with some content in filename.xlsx. Do you want us to try to recover as much as we can?" 

 

It is only impacting some users and it seems to be a PowerSchool issue when exporting. We have had the user try different machines, different office years - 2016 and 2019 excel and nothing works. Anyone have a work around?

3 Replies
JyotishkaB
Community Support Expert
Community Support Expert

Hi @Eggsolint 

 

Would you please confirm what data are you trying to export and how? Is it a particular report you are trying to pull?

 

Jyotishka B.
Community Moderator



Remember to give Kudos to suggestions that help you!
If another user helps solve your issue, please select Accept As Solution on their post so others can see the solution, too!

Eggsolint
New Member

  1. Go to your gradebook in PowerSchool (any class)
  2. On the left hand side, go to REPORTS and select “Missing Assignment Report”

Eggsolint_0-1701091569244.png

 

 

 

  1. Choose the “Format” tab

Eggsolint_1-1701091569249.jpeg

 

 

  1. Set “Output” to Excel

Eggsolint_2-1701091569253.jpeg

 

 

 

  1. Choose the “Criteria” tab

 

Eggsolint_3-1701091569255.jpeg

 

 

  1. Next to Classes, click the dropdown box to “Select Classes” 

Eggsolint_4-1701091569258.jpeg

 

 

  1. Check the box next to “Other Classes” to select all classes (even if it is not the right semester, it doesn’t matter)

Eggsolint_5-1701091569264.jpeg

 

 

  1. Further down in the “Data” section, select the dropdown that says “Select

Assignments”

 

Eggsolint_6-1701091569266.jpeg

 

 

  1. Check all the boxes in this menu

Eggsolint_7-1701091569269.jpeg

 

 

 

  1. Further down in “Date Range”, click the drop down and choose “Manual”

 

Eggsolint_8-1701091569271.png

 

 

  1. Enter the 2-week period needed

(The first time is 8/7/2023 to 8/18/2023)

 

 

 

 

  1. Select “Run Report” in the bottom right hand corner

 

Eggsolint_9-1701091569274.jpeg

 

 

 

  1. Select “View Reports”

Eggsolint_10-1701091569276.png

 

 

  1. Open the missing assignment report

Eggsolint_11-1701091569278.png

 

 

  1. Save it 

Email the report to Heather Herrington by 8:00 AM Monday

 

 

After all of this, two users are getting the "We found a problem with some content in filename.xlsx. Do you want us to try to recover as much as we can?" error when trying to export to Excel. 

JyotishkaB
Community Support Expert
Community Support Expert

Hi @Eggsolint 

 

We recommend that you report this error to your district's Technical Contact who should be able to submit a ticket on your behalf and working with the support team to reproduce the issue and investigate further.

 

 

Jyotishka B.
Community Moderator



Remember to give Kudos to suggestions that help you!
If another user helps solve your issue, please select Accept As Solution on their post so others can see the solution, too!