how did he do this

[dspel79082]

Hi all,

The following formula is from one of the bosses spreadsheets. He is a heavy spreadsheet user but his formula skills stop around =a1+b1. He is a huge fan of copy/paste.
So needless to say there is a lot of 'fixing' to be done, by yours truly.

I am usually able to figure out what he did to cause the issue but I need help with this one.

He unsucessfully tried to delete the contents of one of the cells that contain the following array formula

{=Excel.Sheet.12|'C:\Users\xx\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.Outlook\xxxxxx\xxxxxx - FINAL 2018 PRICING.xlsx'!'!Sheet1!R6004C1:R6015C4'}

I know how to fix this, but what I'm am really hoping for help with is what method he used to create this.
I can see that it was probably a read only copy of a file from email, but I cannot recreate any kind of copy/paste or simple '=' formula that results in this. I know he didn't write the formula.

Anyone?

 

[anglais428]

Do you have access to the file? That would be the best place to start. If not, as it looks like a temporary file, you would need to access the original source and redo the formula