Error in formula when working on a sharepoint file.

Question

We have created an excel file ETIQUETABLANCA2023.XLS to have some information that I have linked by some queries this file CONTROL LOCATIONS 2022.XLSM and it shows the results in my sheet.

When I make/create the query it works correctly since I do it to the file in my Onedrive.

The problem appears at the moment I close the local file [CONTROL LOCATIONS 2022.XLSM] if user modifies the file, if I open my document the formula that I have done, changes it the formula still exists but changes the path that works : "=SUM. IF('[CONTROL LOCATIONS 2022.xlsm]DADES'!$M$12:$M$511;A96;'[CONTROL LOCATIONS 2022.xlsm]DADES'!$O$12:$O$515)"

for this OTHER one of HTTPS: "=SUM. IF('https://xlabelsolucions.sharepoint.com/sites/x-label/Documentos shared/MAGAZTEM 2019/Control Ubicacions/[CONTROL UBICACIONS 2022.xlsm]DADES'!$M$12:$M$511;A96;'https://xlabelsolucions.sharepoint.com/sites/x-label/Documentos shared/MAGAZTEM 2019/Control Ubicacions/[CONTROL UBICACIONS 2022.xlsm]DADES'!$O$12:$O$515)"

is from "local " to "sharepoint" and I can't see anything. the document only shows [VALUE].

When I get the modified formula,

If open the file CONTROL UBICACIONS 2022.XLSM and then I modify the formula to local and the data comes out correctly. It is as if I open the sharepoint file in local and then it works again.

The question is if it is possible to link the formula directly to the sharepoint location. and I can see the updated data.

Answer 1

I am sorry I did not explain well, the problem persists, I have checked your information and the links are correct and connected, but it still does not show the value of the applied formula, instead VALUE appears.

Answer 2

Esta respuesta se ha traducido automáticamente. Como resultado, puede haber errores gramaticales o expresiones extrañas.

Siéntete libre de compartir cualquier actualización si necesitas más ayuda al respecto:)

Answer 3

Hi Snow Lu

sorry i see this information and its ok..

i dont understand what happen :(

Answer 4

Hi Snow Lu

sorry i see this information and its ok..

i dont understand what happen :(

Answer 5

Esta respuesta se ha traducido automáticamente. Como resultado, puede haber errores gramaticales o expresiones extrañas.

Puede probar los enlaces de libros de trabajo.

Compatibilidad con vínculos de libros disponibles en Excel para la Web - Centro de comunidad de Microsoft