•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Transposing an array from another OneDrive document
Our take
Hi everyone,
I’m looking for assistance with transposing a table column from another workbook in Excel for the web. While accessing the documents via desktop apps yields the expected values, the web version returns a #REF error. I’ve attempted to use the "Get Data" function to import the data, but I’m facing challenges with it in the web environment. I recognize there are limitations with the web version, so any workaround suggestions would be greatly appreciated. Thank you!
Submitted by /u/XenoAshen. [link] [comments].
Hi all,
I'm trying to transpose a table column from another workbook in excel for web, opening the documents on the desktop apps returns the required values but the web version displays #ref.
Does anyone know of a workaround for this. I've tried using get data to pull the data in from the other document first but can't get that working on the web version. I understand the web versions comes with limitations.
The formula used is
=transpose('https://d.docs.live.net/E0363ccc2ef552a6/26-27 player database.xlsx'!squad_players[player name])
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Tagged with
#Excel alternatives for data analysis#generative AI for data analysis#natural language processing for spreadsheets#big data management in spreadsheets#conversational data analysis#Excel compatibility#real-time data collaboration#intelligent data visualization#data visualization tools#enterprise data management#big data performance#Excel alternatives#data analysis tools#data cleaning solutions#rows.com#AI formula generation techniques#financial modeling with spreadsheets#formula generator#Excel#transpose