excel online

Morning all So I'm using Excel Online within OneDrive which has a workbook with multiple sheets. Sheet 1 has each row with a load of data relating to the unique entry in cell A. Sheet 2 has rows of data where multiple rows (not necessarily in order) may have info relating to that unique entry...

We have a shared Excel file stored in Teams files. Teams likes to open it in Excel Online by default. It's a simple price calculator and for the most of us it works just as well in Excel Online and in Excel App but for a couple users the Online version handles numbers entered manually as text...

I'm creating a booking page with micrsoft bookings and I'd like to gather all the bookings in an excel file like a table or something, I don't know if it might be better in dataverse? I'm not sure. The file that can be exported from microsoft bookings is an tsv file

Hey Mr. Excel Boards, So, the short question is that, is there any way to display/add the refresh date to an online pivot table? Long question: I / my boss has built a PowerAutomate (cloud) flow that iterates over a bunch of excel documents in sharepoint, then runs an office script in each...

Good Afternoon All, I have an automatic system that downloads data to excel online, as you can see below in the table this is how the downloaded data comes. I am trying to either make a formula or something that can sort the "null" changed column to only include data with No selected as an...

I have a Power Automate flow running that adds rows of Associate information into sheets of an Excel online spreadsheet. I would like to set up conditional formatting so that it highlights rows that have the same "Associate Id#" (First column in each sheet) when that ID number occurs three...

I don't know if this is going to make much sense to the experts as I have only taken an intro course and fiddled around a little in the last few months with excel getting more acquainted, however now that I have some basics and some ornamental excel stuff down I am getting a little more...

Hi, I am trying to import data from onedrive excel file to excel desktop through power query. (using add-in on Excel 2010). 1. If i copy below links in power query>import from web, import selection space is not showing sheets in the file 2. If i select to open file in desktop app, it is asking...

Hi All, I've got a workbook saved to a SharePoint folder. In the workbook is a script. See below. Its the part in bold i need help with. Basically the script needs to add a header to the sheet and a footer at the bottom of the set of data (row number can change daily). The script adding...

Hey All, I have created data validation fields in several worksheets. When using them in Excel Online, I used to be able to start typing and have an auto filtered list popup based on what I had input to that point. Suddenly, this autofill feature is no longer there. Is anyone else having this...

hi friends! I currently am sorting my sheet like the attached page. Basically I have a few unique numbers, want to add a comment next to it, then lookup the value against full columns where the number exists in the data table in col I&J. Then I want to add the comment to each replicate of the...

Hi, I've tried to search for solutions but to no avail. I have an Excel Online (365) file which contains all emails that entered a shared mailbox. I've created a search box to allow the user to type a specific word to search for emails that contained the text in the body of the email. All works...

Cyclic references do show up. It is not difficult to inadvertedly create one. Excel for desktop most of the time tells us about the fact immediately and demonstrates where the cycle is. However, if the cycle is created by values which are spilled to neighboring cells, we get only a warning...

Hello all, i'm using excel online to edit some of my data. after a few copies and pasting, my excel table became a mess. please refer to uploud image. is it because of my slow internet problem ? or other thing ? please help

In desktop version we are using the camera tool to show a graph that the user pasts into a different worksheet. When we put this file in excel online this function is not available and the user can not paste the graph from the downloaded excel to excel online. Does anyone have any ideas of how...

Here is my struggles. I had macros in my excel document which everything was working fine. We kept coming up with the problem that in order for someone to use it and they worked from home they had to vpn in. Next thing was if someone has to use it and make a change and another user has it open...

Hello, In Excel 2016, the shortcut key for current date is CTRL + ; For current time the shortcut key is: Shift+CTRL+; Are there similar shortcut keys in the online version of Excel? I can only find basic shortcut keys for navigation etc... Thanks

Hi Guys, I hope you guys can help me out with this problem. I want to share a file on Sharepoint with 9 different users that use Excel Online (So macro's wont work). Each user has his own sheet, but they must not be able to edit each-other's sheet. They are not able to re-apply sheet...

Hey, So basically I have an excel-workbook where the background is colored light grey and there is a table with "normal" black borders and one thick black border under the top row. When viewing/editing the file in Excel (offline) everthing looks like it should, but in Excel Online some of the...

Hi everyone, Hope you are well. I would like to import daily data from JSON via an API into my Excel Online sheet. It is very important that it is Excel Online because it is for collaboration purpose. If I am right, this is not possible. However, could I, as a first step, import Json into a...