This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hello,
I tried to use the "copying data from other worksheet/excel files (='[file A.xlsx]sheet1'!column) formula to copy the data to other files.
Lets say that i typed ='[file A.xlsx]JULI 2024'!D25 **** formula to file B's JULI sheet, the formula works. Then i copied the same formula ='[file A.xlsx]AGUSTUS 2024'!D25 **** to file B's AGUSTUS sheet. It shows an error message:
"Excel found a problem with one of more formula references in this worksheet.
Check that the cell references, range names, defined names, and links to other workbooks in your formulas are all correct."
I also tried to tried the same "JULI 2024" formula to AGUSTUS sheet, it works too. I initially thought that it is impossible to put more than one formulas to one worksheet. But when I tried to use the formula with "OKTOBER 2024" it also works successfully. The error message only appeared for "AGUSTUS 2024" and "SEPTEMBER 2024". I already did the crosschecks for a few times in case that I typed the formula names incorrectly, but nope. Everything was the same. I dont know where the incorrect part that makes the formula doesnt work.
Could anyone help me with this case?
Thanks in advance!
Screenshots:
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Could there be a space after 2024 in the name of the AGUSTUS 2024 sheet?