Spreadsheets in Space just became more powerful with a new API in Microsoft Excel
We are always looking for new ways to help people do more and create new experiences, so the Excel team was excited to collaborate with CCP Games as they developed a powerful new Excel add-in that will supercharge the EVE Online game experience by making data analytics accessible to all players, no programming knowledge required. This valuable tool enables players of all skill levels to effortlessly access and analyze data to optimize gameplay as they strive for galactic domination.
Excel data link without permission in Sharepoint
Good morning, please excuse if the terms I use are not correct, Excel is not running in English, so all terms I use are translated. I've got an Excel sheet with some data links to other Excel sheets. Let's call this sheet A. I access the other sheets (let's call them sheets B-F) via sharepoint, they're shared by a colleague via onedrive. Now I shared my sheet A with a third colleague, works fine. BUT: As the data in sheet A should be automatically updated from sheets B-F, the latter colleague is asked to sign in with another account, because he has no access to sheets B-F. Can I somehow give access to the relevant data of sheets B-F for each user of sheet A without giving them access to whole files? Thanks in advance for your help!
Excel - auto-transfer data between column
Hello, I have column A to G. In the column B were listed first and the last names in alphabetical order. In the column F the same first and the last names from column B were listed without any order. Column C is empty. Column G have data related to the column F. What I need? I need the name from column B to be recognized from column F and the data from column G to be automatically assigned to the column C. Please see the screenshot below. From the screenshots: B1 to be recognized from F (in this case F7) and G7 to be automatically added to C1. B2 to be recognized as F6 and G6 to be automatically added to C2. The most important is data from column B to be recognized in F if that is possible. Any help is much appreciated. Thank you!
Maps Data for Scotland
Hi, Apologies if this has been answered elsewhere but I'm trying to create a map chart for Scottish Local Authorties (Council regions) and I have all of their official names but the Maps chart isn't having it. Is there a list somewhere for how I should be naming these or am I missing anything else? I've attached a picture of my data. Thanks, Chris
Excel Version 1907 [Expression.Error] This native database query isn't currently supported
I have a file that contains a data connection that has been working for months. It recently stopped working after the 1907 update applied. Is anyone else experiencing an issue? How might I go about determining what part of the native query is causing the issue? I have also converted the query to a stored procedure and it doesn't work either. Is there a way to get more detailed error information?
Taking values from certain rows based on data input
So I'm trying to get a value into the column "Cat A Tied" (C column). This value depends on the number in the "# People Tied With" column (D Column). In this case, cell D2 has the number 3 in it. I want the sum of the first three rows of the B column (not including column headers) and then divide that by 3. However, I want the cell to be dynamic so if I change the number to 5 it will then automatically take the sum of the first 5 rows and divide by 5. Additionally, if I put this value into D3, the second row of my table, I'd want the first number (3 or 5, or any number put in) of rows from that same row onwards instead of from the first row of the data set. Any help would be greatly appreciated 🙂
