Forum Discussion

Serenalip's avatar
Serenalip
Copper Contributor
Sep 24, 2021

How to automatically copy data from one Excel tab to another tab (same worksheet) in Sharepoint

Hi there.

 

I have uploaded an Excel sheet to Sharepoint and I'm trying to find a formula to automatically copy data from one Excel tab (tab 2) to another Excel tab (tab 3) in Sharepoint but it doesn't work. I am finding that the formula's that usually work in Microsoft Excel don't work as soon as it's uploaded to Sharepoint. Any ideas?

Excel for web
Formulas and Functions

1 Reply

  • Yea_So's avatar
    Yea_So
    Bronze Contributor
    Oct 02, 2021

    Serenalip 

     

    https://social.technet.microsoft.com/Forums/en-US/5cb1bcf9-4838-4127-b86a-297f2cf7bbd0/sharepoint-online-amp-excel-formula-reference

     

    once you upload it in sharepoint the formula references change to a url. see link

Resources