Work on a copy with Excel online, without opening the desktop app.

%3CLINGO-SUB%20id%3D%22lingo-sub-2202491%22%20slang%3D%22en-US%22%3EWork%20on%20a%20copy%20with%20Excel%20online%2C%20without%20opening%20the%20desktop%20app.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2202491%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EThis%20is%20the%20scenario%3C%2FP%3E%3CP%3ETwo%20Excel%20documents.%20(one%20for%20managers%20and%20one%20for%20employees)%2C.%20Emmployees%20works%20on%20a%20copy.%3C%2FP%3E%3CP%3EIt%20works%20fine%20if%20both%20worksheets%20are%20opened%20in%20the%20Desktop%20version%2C%20but%20not%20online%20version.%3C%2FP%3E%3CP%3EWhat%20I%20did.%20I%20made%20a%20second%20worksheet.%20Copied%20one%20tab%20to%20the%20new%20worksheet.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22update%20excel%20online.PNG%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F262788i173F0869ED6C1F3A%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22update%20excel%20online.PNG%22%20alt%3D%22update%20excel%20online.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EManager%20and%20Project%20is%20the%20source%20for%20Weekplan%20in%20both%20sheets.%20Updated%20by%20changing%20the%20weeknumber%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20the%20Desktop%20version%20it%20works%2C%20in%20the%20web%2Fonline%20version%20we%20get%20%23ref.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EURL%20difference%20in%20the%20dekstop%20and%20web(online%20version%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22url%20desktop.PNG%22%20style%3D%22width%3A%20994px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F262790i951E9E83ACA316A8%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22url%20desktop.PNG%22%20alt%3D%22url%20desktop.PNG%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22url%20web.PNG%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F262791i347F121BF90ACB9C%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22url%20web.PNG%22%20alt%3D%22url%20web.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20this%20a%20possible%20scenarios.%20Or%20is%20using%20the%20desktop%20version%20the%20only%20option%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20regards%3C%2FP%3E%3CP%3E-%20Geir%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2202491%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Regular Contributor

Hi,

This is the scenario

Two Excel documents. (one for managers and one for employees),. Emmployees works on a copy.

It works fine if both worksheets are opened in the Desktop version, but not online version.

What I did. I made a second worksheet. Copied one tab to the new worksheet.

update excel online.PNG

Manager and Project is the source for Weekplan in both sheets. Updated by changing the weeknumber

 

In the Desktop version it works, in the web/online version we get #ref.

 

URL difference in the dekstop and web(online version

 

url desktop.PNGurl web.PNG

 

Is this a possible scenarios. Or is using the desktop version the only option?

 

Best regards

- Geir

0 Replies