Jan 10 2024 11:57 PM - edited Jan 11 2024 12:10 AM
Good morning
I have linked data from an array from one Excel workbook to another (i.e. separate files). When the data from an array in one workbook is pulled to the other, the destination workbook has formulae which are applied to the imported data, however, they return a #VALUE error. But if the data is pasted as values manually, the formulae work and return correct values.
The idea is, when I drop the Excel files in the same folder, one will pull the values from the other and use the imported data to conduct internal calculations and update charts.
p.s. I am using MS 365 at work so I am assuming it is the latest version of Excel.
I would appreciate any assistance
Jan 11 2024 09:39 PM
The #VALUE! error in Excel usually indicates a problem with the data type or structure in a formula. When working with linked data between different workbooks, there are a few potential reasons for encountering this error. Here are some steps you can take to troubleshoot and resolve the issue:
The text and steps were edited with the help of AI.
If the issue persists, you may need to provide more specific details about the formulas and the structure of your workbooks for further assistance.
In this link you will find some more information about it:
Welcome to your Excel discussion space!
My answers are voluntary and without guarantee!
Hope this will help you.
Was the answer useful? Mark as best response and like it!
This will help all forum participants.