yomisma2000
New Member
- Joined
- Feb 29, 2020
- Messages
- 4
- Office Version
- 365
- Platform
- Windows
Good morning
I have a problem with excel365 and sharepoint and I don't know if there is an easy solution to it. I'm from Spain
I have an excel workbook that I use often and that has several workbooks linked to it. These linked workbooks only change once a month so I don't need the linked cells in the workbook I use often to be continuously updated. The problem I have is that when I open my book, and for example, I change a filter that affects cells that are linked to those other workbooks, as I don't have those files opened all the time, the cells linked show the #VALUE! error and I have no choice but to open all linked files.
This annoys me a lot, because there are times when I have links to 20 different files in the file, and having to keep them all opened while working with the one I need to work with is a hassle.
Is there anything I can do so that the links in that file are never updated unless I say so?
I have a problem with excel365 and sharepoint and I don't know if there is an easy solution to it. I'm from Spain
I have an excel workbook that I use often and that has several workbooks linked to it. These linked workbooks only change once a month so I don't need the linked cells in the workbook I use often to be continuously updated. The problem I have is that when I open my book, and for example, I change a filter that affects cells that are linked to those other workbooks, as I don't have those files opened all the time, the cells linked show the #VALUE! error and I have no choice but to open all linked files.
This annoys me a lot, because there are times when I have links to 20 different files in the file, and having to keep them all opened while working with the one I need to work with is a hassle.
Is there anything I can do so that the links in that file are never updated unless I say so?
