Do you have any solution for below scenario ? We have source data in our system network. We are getting details from this source file to "File 1". Source data is closed. I am opening second version of "File "" . Shortyl File 1 and File 1_R00 are open. 2 version of file are getting datas from source file. But when we open 2 file at the same time, after a while, they are changing data automaticallu even I didn2t click update or other thing. Why files are broken when I open 2 different version of files at the same time
I guess - no. Cause excel makes cash of results that you get with formulas, except of may be v/hstack or filter when you have special condition where it returns whole table.🤔
Yes, you're right it is a cache of cell values, not a cache of original data. Though if the cell values and the data are the same; then it might be a useful recovery method.
I don't believe it's an application setting, so it's only on a workbook by workbook basis. You might be able to create a macro in your Personal Macrobook to apply to all workbook as you work with them. The code would include something like: ActiveWorkbook.SaveLinkValues = False
Thank you ! Great video! Now, I would like to know how to purge my pivot tables from old data. I have been building an Excel file for a process in many clients. With each new client we delete the data in the file (no external links) to add the new client's data, but in the pivot tables you can see that it has kept a reference for all previous data (you can hide it, but I want to delete it). Over time, there is quite a lot of data there. I wish there was a purge-and-rebuild button for the pivot tables :)
Awesome, That's neat trick. Thanks so much
Glad you liked it! 👍
A very interesting and important topic Mark. It can be highly dangerous not to disable that option in some scenarios. Great explanation! Thank you!!!
Thanks Ivan. 👍
Is there an option to recover the linked excel workbook, if accidently gets deleted, from the saved xml file?
It’s not an embedded workbook. It’s just the cell values. So, no, I don’t think that’s possible.
Do you have any solution for below scenario ?
We have source data in our system network. We are getting details from this source file to "File 1". Source data is closed. I am opening second version of "File "" . Shortyl File 1 and File 1_R00 are open. 2 version of file are getting datas from source file. But when we open 2 file at the same time, after a while, they are changing data automaticallu even I didn2t click update or other thing. Why files are broken when I open 2 different version of files at the same time
Thanks for the insight, great content. One question, if I break the link, is the information removed from the xml cache"?
At 3:53, if we don't click on the update buttom, willl the cache info carry over?
Now i a understand why my single FILTER formula from over 10mb file makes file that contains that formula same size like that. :)
That could well be the reason. You can unpack the file to check.
@@ExcelOffTheGrid it is interesting second question. Is it possible to restore data from linked file if accidentally original file will be deleted?🤔
I guess - no. Cause excel makes cash of results that you get with formulas, except of may be v/hstack or filter when you have special condition where it returns whole table.🤔
Yes, you're right it is a cache of cell values, not a cache of original data. Though if the cell values and the data are the same; then it might be a useful recovery method.
@@ExcelOffTheGrid thank you for tip.🤗
Very useful information Mark!
I guess there is no way of turning this off for all documents, we need to do it for each document?
I don't believe it's an application setting, so it's only on a workbook by workbook basis.
You might be able to create a macro in your Personal Macrobook to apply to all workbook as you work with them. The code would include something like:
ActiveWorkbook.SaveLinkValues = False
I always wonder why everybody REPLACES extention instead of to ADD new on after dot?
Because otherwise it’s much harder for my brain to read and process.
@@ExcelOffTheGrid for my brain much easier is to delete what you've wrote, than write again what you've delete before.😊
I didn't know it, at all. Thanks so much!
You’re welcome 👍
Thank you, very informative!
Glad it was helpful!
Excellent. I had no idea that this was the case.
Glad it was helpful!
Excellent video very useful
Thank you. I’m glad you like it. 😀
Thank you ! Great video! Now, I would like to know how to purge my pivot tables from old data. I have been building an Excel file for a process in many clients. With each new client we delete the data in the file (no external links) to add the new client's data, but in the pivot tables you can see that it has kept a reference for all previous data (you can hide it, but I want to delete it). Over time, there is quite a lot of data there. I wish there was a purge-and-rebuild button for the pivot tables :)
Hi Ricardo - I think this is what you’re looking for - ruclips.net/video/6k_421-fyGs/видео.html
@@ExcelOffTheGrid Yes! Thank you very much!!