Forum Discussion
office 365 , exell
Windows 11 used Office 365
When I link cells from multiple sheets to one sheet, and when I close all the files and open the file to which the data will be transferred without prior opening the source files, a change occurs in the functions with an error in the name of the sheet it is transferred from in all cells. There is no other error(#Ref!) except the error in changing the name of the sheet. The rest is no problem. If you open the source file before the file you are transferring to, the error will not occur, provided that you avoid moving or changing anything in the files or cells.SergeiBaklan
Sorry for the stupidity, still didn't catch. Assume you have two files, A.xlsx and B.xlsx. The latest is the source file. In A you have something like
=[B.xlsx]Sheet1!$A$1+[B.xlsx]Sheet2!$A$1Now you close both files. Open A only. It shall be no error.
I actually have two files and no functions like this
=[B.xlsx]Sheet1!$A$1+[B.xlsx]Sheet2!$A$1 But there is
='D:\Weight samples\[W1.xlsx]Fe. summary'!C5
Only this function exists and is changed (Fe. summary), and this is the name of the sheet inside the duplicate files
- I say it another way: I have 24 duplicate files, and I have a file that takes each update from these files from the same place in each file, but each file has a different name to understand the results for different days.