I have Access to an Excel shared spreadsheet that I fill the data to it. I need to use some of that information in another Excel shared spreadsheet, but I can't. I am using the information of the address bar of the first spreadsheet on the square parenthesis in the formula like this:
=[https://...]Sheet1!$K$1
(I used https://... instead of the whole address in the example since too long)
Can anyone please help me with that formula?
Excel is only marking the square in red and showing an error in the formula with no details.
