Export items to excel - error

Recently, when trying to export the item library, we get the Excel error "We found a problem with some content in "filename". Do you want to recover as much as we can.  If I click yes, error, if I click no, ends the session.  Any idea how to find out what content is causing this problem, without actually being able to export the file to see any errors?

 

1,001 Views
Message 1 of 6
Report
5 REPLIES 5
Alumni

Hi @Meekomac 

 

I'm not familiar with this Excel error. Can you post a screenshot, and is there any more context you can provide? 

999 Views
Message 2 of 6
Report

I don't seem to be able to upload images.  I am trying to export the item library, as I have hundreds of times - it's just easier to export, update a block of items, then import them back in rather than edit each item in Square Dashboard as I have to scroll all over the place to do so.

From Item Library, I choose Actions, Export Library, To Excel.  The file chugs along for a while, then when complete and I try to open the exported file, I get the error:  We found a problem with some content in 'catalog... xlsx'. Do you want us to try to recover as much as we can? If you trust the source of this workbook, click Yes.

 

If I click yes, it tries to open excel, then repeats the error: Microsoft Excel was attempting to open and repair the file. To start this process again, choose Open and Repair from the Open File Dialog.  And in circles we go.

 

I'm not comfortable using any "repaired" file anyway, not knowing what might be missing or "fixed" and changed, but I'd like to know what's triggering this so I can perhaps fix it in Square to be able to cleanly export again....

995 Views
Message 3 of 6
Report
Alumni

Hmm.. Yes, I have not heard of this before. Can you try opening the file in Google Sheets to confirm if it is the actual file that is corrupted, or if the error is related to the way Excel is trying to open it.

993 Views
Message 4 of 6
Report

Hi
I have the same problem since yesterday

991 Views
Message 5 of 6
Report
Alumni

Hello, @Cycy4422. We regret to learn that you're experiencing the same issue. Have you attempted the troubleshooting steps suggested by @BernadetteA? Could you please offer more details about your specific problem? When did this issue begin for you?

 

We will be on the lookout for your response. 

Sayra
Community Moderator, Square // Moderadora de la Comunidad, Square
Sign in and click Mark as Best Answer if my reply answers your question.
Inicie seción y haga clic en Marcar como "Mejor Respuesta" si mi respuesta contesta su pregunta.
987 Views
Message 6 of 6
Report