Not able to edit the Excel after taking export from a dashboard

Question & Answer
,
1

Hi Guys When i try to take the export as a Excel from a table visual from the Dashboard i am facing below mentioned error message when i try to adding a sheet or copy and pasting
Please help me guys and thanks in advance for any help.
Screenshot 2023-12-14 231838

2

Hi Arpit,

When you take excel data export from QuickSight visual, it is offline data copy and editable.

Prima facie it doesn’t seems to me an issue with QuickSight. It may be some issue with the excel file on client machine.

In order to isolate the issue…
(1) Can you please check whether in same environment you are able to perform add-sheet, paste data.
(2) Can you take QuickSight export on other client machine and reproduce the issue.

Regards,
Anwar Ali

3

Hi Anwar,

1.I am not even able to add a page to the excel download version.
2.i am not having those right to use on other machine.

4

Hello, me and my team are facing this same issue. I did both steps and couldn’t fix the issue.

5

Hi,
I am also facing the same issue, where when I down an excel I cannot add a new sheet or copy paste data from the excel.
We could do the same few months back but not now.

Kindly let us know how to resolve this issue.

7

I found this solution and tested that it works:
Save as the exported file with a different name, close the file and re-open, now it’s editable.

1 Like
8

thanks a lot @zep1219 for this suggestion and it worked.
I want to add a point here that we have both options either save it by a different name or save it by same name and replace existing one then close the opened one and again open the same ,it will also work as expected

9

Thank you for the solution. Can confirm it also worked for me.

10

But team @m3dblue98 @zep1219 @albmargar ,are we able to know that why this issue is coming and how we can handle it at the time of taking export itself

11

Hello @Arpit6075, I have marked the workaround provided by @zep1219 as a solution for this issue. @AnwarAli do you have any other thoughts on why this might be occurring? I went ahead and marked the topic as a possible feature request in case it is something that can be resolved by the Support Team, but I am curious if you still think it is a separate issue. Thank you!