Some Users having an Excel error when exporting from Powerschool

[Eggsolint]

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?

[JyotishkaB]

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?

[Eggsolint]

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

1. Choose the “Format” tab

1. Set “Output” to Excel

1. Choose the “Criteria” tab

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

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

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

Assignments”

1. Check all the boxes in this menu

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

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

1. Select “View Reports”

1. Open the missing assignment report

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]

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.