online

now that i have got my sheet working and updating each sheet i want to send this excel sheet to people and have it update a excel workbook online

Created a workbook for my fellow colleagues to collaborate on. After loading it to SharePoint and opening it on the excel online I noticed none of my data validations and some conditional formatting is gone. Is there anything I can do about it because it renders my workbook useless otherwise...

I am trying to have the file name, be made automatic as we save it I would like this file to be named: "Meriden Online 04-23-2019" When finished I keep getting a save as method failed error here is what I have so far Dim Path As String Dim filename As String...

Hi all, I work at a school and got a (probably educational) powerbi pro license. I want to experiment with powerbi dataflows but cannot see the functionality in the powerbi online service. Anyone knows why? Kind regards, MrJoosten

I have created one online excel file, and after 2 months when i try to get into the link, shows me a window and tells me that "Too Many Objects, There are to many objects (charts, shapes, pictures etc to display. ........)" But in this file i don't have, charts shapes etc.. How can i fix it?

How can I tell -- by talking to someone over the phone -- if they have a local install of Excel? I've sent 2 people a macro file and the macros don't work. I believe they're using the online version, but I don't know REALLY how to tell (save a copy seems to be one way?). And then, I helped one...

Hi Everyone, We are looking for any recommendations on the various online database options(Caspio, ZOHO, etc) to store Excel tables on a daily basis. Thank you!

Do macros work with Excel Online? I have a spreadsheet that executes check digit code after the user enters that value in the cell.

Hi, I was hoping to use the outline button to allow users to expand some fields in a spreadsheet on share point. But the sheet opens in excel online where VBA is not allowed. The only way I know to use the group(+) on protected sheets is via a macro. Has this been resolved or addressed on...

Hi all, I have an excel file which could not be opened anymore from one day to next. The loading bar usually stops at ~80% and then excel freezes and is not responding anymore (according to task manager). CPU workload and memory usage are both below 15%, respectively. Using excel online, the...

If I have a list of telephone numbers on excel is there a way for it to look each number up online and return what company each number belongs to. I am sure I have seen someone do this but not sure how.

This is just a question out of curiosity. It's about reading files that are stored online like txt, log or csv files. I know I can download these files and do my thing but that's not the issue here. When I run this code for example I can read the information in the online stored txt file and...

Hi folks, I am wondering is there a way to summarise the table below so that it lets me know if an event had only newcomers, only returns, or returns and newcomers. For instance, I am trying to distill this table down to: On 11/11/19, the "Shop" had "New and Return" customers while the "Show"...

Dear Sirs, I have one problem with evaluation function. <tbody> Online file name Link made by CONCATENATE funcеion (string) test1 00 123 3123.xlsm "='http://test.test.com/Manufacturing//[test1 00 123 3123.xlsm]Sheet1'!$B2" test2 90 43 4.xlsm "='http://test.test.com/Manufacturing//[test2...

Hello, I am been tasked at work to compile a report in Excel. It will gather both text and numeric data and will be completed by 50+ organizations. I also need to make it as easy as possible for us to comb through the data. My manager doesn't want to receive 50+ copies of the same workbook...

Hi I've heard that MS will stop supporting 'Access Services' in SharePoint Online but I'm not quite sure what that means. Currently I have several desktop databases linked to lists within SharePoint Online and they work quite well. Does this mean the ability to use a SharePoint list like a...

Hi, I would like to sign up for an ideally inexpensive online course covering Excel dashboards. There seem to be lots of different options including quite a long list on Udemy. Is anyone please able to recommend a good online course? Thanks!

Hi guys I've created a new workbook recently, one of it's functions is to pull the start of a worksheet name, which then in turn populates other data. eg. MrExcel_bla_123 'MrExcel' will get pulled into the cell, using the following formula:-...

Hey Guys, I'm trying to get code written that will select the next column but am having trouble finding it online, and or just wrapping my head around how to do it, Please Help Thanks

Hey all, I am charting into unknown territory with pulling data from online website using VBA. I have some VBA experience manipulating data within workbooks, but lack the know how to update from an online source. Here is a synopsis of what I am trying to accomplish. Any help is greatly...