Forum Discussion
Filter function in Excel 365 does not work with linked file which is open.
I am facing problem when I refer to one excel file from other file thru Filter() in Excel 365. I have one large file (File A) with my data having more than 200000 records. Just to see only spe...
Perhaps Power Query could be an option. The only it requires manual refresh to have recent changes in source file.
- Thanks for your reply Sergei. I thought that as well.
But With power query, when the other file A is open to update more data, power query does not get refreshed. it gives error that can not refresh query because the source file is in use. Can I set power query to run with open file as well. Although such situation comes less often, a solution always helps.Yes, that's an issue if you query the file from mapped local drive. If get file from the cloud (File->Info-> Get path, remove ?web=1 at the end and use From Web connector) it works if source file is opened. But that requires internet connection which is not always suitable while travelling.
Not sure if the workaround for all cases exists.
Hello SergeiBaklan
Thank you. I will check this option.
