Home

Excel 2013 to 2016 --> #value in cells that invoques other files

%3CLINGO-SUB%20id%3D%22lingo-sub-1192882%22%20slang%3D%22fr-FR%22%3EExcel%202013%20to%202016%20--%20%23value%20in%20cells%20that%20invokes%20other%20files%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1192882%22%20slang%3D%22fr-FR%22%3E%3CP%3EGood%20morning%3C%2FP%3E%3CP%3EI%20have%20on%20a%20Server%20an%20Excel%20file%20(created%20with%20Excel%202013)%20which%20invokes%20values%20from%20other%20Excel%20files.%20Without%20oppening%20all%20the%20Excel%20files%2C%20using%20Excel%202013%2C%20I%20am%20able%20to%20see%20all%20the%20data%20that%20comes%20from%20them.%3C%2FP%3E%3CP%3EWith%20Excel%202016%2C%20%23value%20is%20written%20on%20all%20the%20values%20coming%20from%20the%20other%20files.%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20to%20prevent%20this%3F%20Some%20parameters%20to%20change%20maybe%3F%3C%2FP%3E%3CP%3EI%20thank%20you%20in%20advance%20for%20your%20help%20and%20wish%20you%20a%20nice%20day%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1192882%22%20slang%3D%22fr-FR%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1193729%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%202013%20to%202016%20--%26gt%3B%20%23value%20in%20cells%20that%20invoques%20other%20files%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1193729%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F567391%22%20target%3D%22_blank%22%3E%40Eugy94%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThere%20are%20a%20number%20of%20reasons%20that%20a%20formula%20might%20return%20%23VALUE!%3C%2FP%3E%3CP%3EPerhaps%20you%20could%20share%20your%20formula%20to%20help%20us%20find%20the%20root%20of%20the%20error%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1203995%22%20slang%3D%22fr-FR%22%3ERe%3A%20Excel%202013%20to%202016%20--%20%23value%20in%20cells%20that%20invokes%20other%20files%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1203995%22%20slang%3D%22fr-FR%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F360420%22%20target%3D%22_blank%22%3E%40PReagan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHello%20and%20thank%20you%20for%20your%20reply.%3C%2FP%3E%3CP%3EMy%20Excel%20document%20is%20linked%20to%20multiple%20other%20documents.%20Data%20from%20these%20documents%20are%20called%20in%20my%20document.%3C%2FP%3E%3CP%3EFor%20instance%2C%20in%20one%20cell%3A%3C%2FP%3E%3CP%3EI'SOMME.SI.%20ENS%20(Documentonserver.xlsx%5DMatrix'!%24A%3A%24A%3B%20%5BDocumentonserver.xlsx%5D%20Matrix'!%24B%3A%24B%3B%20Q3%3B'%20%5BDocumentonserver.xlsx%5D%20Matrix'!%24C%3A%24C%3B%24B%247)%3C%2FP%3E%3CP%3EExcel%202013%3A%20I%20see%20the%20content%3C%2FP%3E%3CP%3EExcel%202016%3A%20%23Value%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Good morning

I have on a Server an Excel file (created with Excel 2013) which invoques values from other Excel files. Without oppening all the Excel files, using Excel 2013, I am able to see all the data that Comes from them.

With Excel 2016, #value is written on all the values coming from the other files.

Is there a way to prevent this ? Some parameters to change maybe ?

I thank you in advance for your help and wish you a nice day

2 Replies

Hello @Eugy94,

 

There are a number of reasons that a formula might return #VALUE!

Perhaps you could share your formula to help us find the root of the error?

Highlighted

@PReagan 

Hello and thank you for your reply.

My Excel document is linked to multiple other documents. Data from these documents are called in my document.

For instance, in one cell:

=SOMME.SI.ENS(Documentonserver.xlsx]Matrix'!$A:$A;[Documentonserver.xlsx]Matrix'!$B:$B;Q3;'[Documentonserver.xlsx]Matrix'!$C:$C;$B$7)

Excel 2013: I see the content

Excel 2016: #Value