Excel 2013 report - There is already data in..Do you want to replace it?

Question

_{Tuesday, June 9, 2015 3:24 PM}

One of the excel reports I have suddenly is now opening with the following message " There is already data in REPORT_NAME.xlsx. Do you want to replace it?

what does this mean?

tatiana

All replies (10)

_{Wednesday, June 10, 2015 5:31 AM ✅Answered}

Hi Tatiana,

Based on your description, could you tell me when you receive the pop-up message what were you doing? I tested it in my own environment and I got the pop-up message as shown in the following figure. Was this the same pop-up message you got in your excel file?

If yes, this message pop-up when I drag something from one part of a worksheet to another. If there's already something in that destination cell, Excel asks me if I'm sure I want to do this.

If you don’t want to receive this message you can turn off the feature in excel:

1. Click File
2. Click the Options button
3. Click Advanced
4. Remove the check mark from Alert before overwriting cells, then click OK

If you pop-up message is different from me, please upload a screenshot and be a bit more precise explain when did you get this message, if this pop-up message have an effect on your file etc. So that I can get more accurate solutions to this problem. I’m glad to help and follow up your reply.

Hope it’s helpful.

Regards,

George Zhao
Forum Support
________________________________________
Come back and mark the replies as answers if they help and unmark them if they provide no

help.
If you have any feedback on our support, please click "[email protected]"

_{Thursday, June 11, 2015 3:26 PM}

thanks so much for your reply George.

The message i get is when i first open an Excel report and it looks like this. 

tatiana

_{Friday, June 12, 2015 2:38 AM}

Hi Tatiana,

Thanks for your reply. Based on your message dialog box, I can’t reproduce your issue. You said this message pop-up when you open an Excel file.

Did you check if this issue also appeared in safe mode?

First I suggest you check if it works fine in safe mode.

Then you can check if this message still pop-up in other use’s computer.

Did your excel file contain links, formulas, etc.? Please check if these contents in your excel file works fine.

I suggest you can upload a sample via OneDrive.

Or if possible, you could send this file to our email address:

[email protected] I'd like to help you check it.

Please Note: The email subject you should use the URL or the Title Name of your case.

And you please be a bit more precise explain your issue (For example what were you donging when you get this message, and where did the file store, if this issue only appeared in only a particular file, etc.?) so that I can get more accurate solutions to this problem. I’m glad to help and follow up your reply.

Regards,

George Zhao
Forum Support
________________________________________
Come back and mark the replies as answers if they help and unmark them if they provide no

help.
If you have any feedback on our support, please click "[email protected]"

_{Monday, June 15, 2015 1:06 AM}

Hi,

Just checking in to see if the information was helpful. Please let us know if you would like further assistance.

Thanks

George Zhao
Forum Support
________________________________________
Come back and mark the replies as answers if they help and unmark them if they provide no help.
If you have any feedback on our support, please click "[email protected]"

_{Friday, June 19, 2015 8:43 AM}

Hi,
I'm marking the reply as answer as there has been no update for a couple of days.
If you come back to find it doesn't work for you, please reply to us and unmark the answer.

Thanks

George Zhao
Forum Support
________________________________________
Come back and mark the replies as answers if they help and unmark them if they provide no help.
If you have any feedback on our support, please click "[email protected]"

_{Friday, September 18, 2015 5:15 PM}

Hello George. I get the same message as Tatiana but mine happens when I insert a pivot table in a specific cell.  There are no values or formula on that cell and it does not overlap with any tables.  Please advise.

_{Monday, November 14, 2016 4:21 PM | 1 vote}

Hello George. I get the same message as Tatiana but mine happens when I insert a pivot table in a specific cell.  There are no values or formula on that cell and it does not overlap with any tables.  Please advise.

I get this message when I try to refresh a pivot table. The same table has been refreshed weekly for months with no problem until today.

_{Friday, February 24, 2017 4:09 PM | 1 vote}

Hi George,

I get the same dialogue box when refreshing a pivot table (despite the pivot table not changing in size).

This is not an issue for me when I only have the one pivot table however becomes a problem when I have a workbook with dozens of them as I have to click for each pivot table and it pretty frustrating.

I have tried deselecting 'Alert before overwriting cells' but this doesn't resolve the issue. 

Is there anything else you can suggest?

Thanks,

Rory

_{Monday, August 12, 2019 4:00 PM | 1 vote}

Hi George,

I am also getting this message all of a sudden.  I have been using this spreadsheet for months and today when I refresh all this error pops up.  "There's already data in (Daily Issues Log)Pivots. Do you want to replace?"  Even if I hit the X to close or hit No all of my pivot charts and tables disappear.

_{Wednesday, October 16, 2019 1:38 PM}

I am having the exact same problem.