External Link Shows #VALUE When Source File is Closed

**ell_** · 06-11-2019, 11:02 PM

Hi, all

I have this specific formula which links the data from external Excel files. But I noticed whenever I close the source files, the result will show #VALUE and data will only be shown if I open the source files.

How can I set my files in order for the main file to work without opening the source files? Does it relate to path of files?

My formula is as below for example:

Please Login or Register  to view this content.

Thanks in advance. Appreciate your assistance.

**FDibbins** · 06-11-2019, 11:35 PM

Short answer - with that function, you cant - the source needs to be open.

What exactly are you trying to do?

**ell_** · 06-12-2019, 05:36 AM

Hi, FDibbins

This formula is actually similar to the action of transpose. My source file have data in horizontal manner but my main file must be in vertical manner. Since I need the number to be pasted as link as well as transpose so I came out with this formula. Hereby I attached file for example.

Thanks for the help.

**FDibbins** · 06-12-2019, 11:52 PM

uplad sample excel file, not zip files, plz. If the files are so big you have to zip them, then you are providing way too much data. We only need enough data to show what you are working with, and what you want.