Source error not found
lejux66
Posted messages
1
Status
Membre
-
Raymond PENTIER Posted messages 58548 Registration date Status Contributeur Last intervention -
Raymond PENTIER Posted messages 58548 Registration date Status Contributeur Last intervention -
Hello,
We have a CRM software that allows us to make orders, invoices, quotes, etc.
I can only extract my quote in Excel format. It turns out that the extracted quote is quite raw.
I created a link between 2 Excel workbooks, (one with the raw file "saved quote" and another "layout" that copies the first one with a more suitable formatting) and I get the message "Source Error Not Found" that appears when the "source" workbook is closed.
However, I noticed that when I extract my quote without saving it directly to "saved quote" and I save it elsewhere, then reopen it and save it to "saved quote," it works; I no longer need to have the file open for it to work. I don't understand why.
Therefore, I would like to be able to extract my file to the "layout" workbook and have the link established automatically without having to open it.
I don't know if I was clear.
Thank you for your help.
Best regards,
Julien
We have a CRM software that allows us to make orders, invoices, quotes, etc.
I can only extract my quote in Excel format. It turns out that the extracted quote is quite raw.
I created a link between 2 Excel workbooks, (one with the raw file "saved quote" and another "layout" that copies the first one with a more suitable formatting) and I get the message "Source Error Not Found" that appears when the "source" workbook is closed.
However, I noticed that when I extract my quote without saving it directly to "saved quote" and I save it elsewhere, then reopen it and save it to "saved quote," it works; I no longer need to have the file open for it to work. I don't understand why.
Therefore, I would like to be able to extract my file to the "layout" workbook and have the link established automatically without having to open it.
I don't know if I was clear.
Thank you for your help.
Best regards,
Julien
