Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [excel-online]

Questions about Excel Online, part of the Office Online suite of web applications from Microsoft

0
votes
1answer
16 views

Copying a cell and pasting in another app pastes the formula not the value

Excel-online is copying the cell formula, not the cell value to the computers clipboard, e.g. Given that I copy a cell showing a value in Excel online When I paste, the formula is pasted instead of ...
0
votes
1answer
16 views

Built-in functions in Excel Online are in a different language from the user interface

Previously I was using my Microsoft account in Turkish, but I set to English a few years ago. All applications were working as expected until I tried the built-in functions in Excel Online. For ...
0
votes
1answer
12 views

How to convert my Excel file so I can edit it in OpenOffice

How can I get my MS Excel document converted for editing in OpenOffice?
0
votes
0answers
21 views

Allow editing of Office 365 docs online only?

My company has an Office 365 + OneDrive for Business subscription. My group has some docs (Excel mostly), which many of us are editing concurrently, and emailing the "current" version to each other ...
1
vote
0answers
15 views

Finding source data behind errors in Excel 365 unpivot operation

I am working with Excel 365. My main worksheet has these fields: Ref-field1, ref-field2, ref-field3, ... ref-field30, value1, value2, value3 … value13, total Ref-field1 thru 30 ...
0
votes
1answer
524 views

Office 365 Excel set region

I have my laptop, running Windows 10, set to English United States region, my O365 site region is set to United States, all excel formatting is set to display dates in US format mm/dd/yyyy, however ...
0
votes
2answers
53 views

Automatically apply new formatting and remove time from a dynamically added Date-Time in google sheets

I am new to Google sheets and don't know how to write excel/google sheet formula to apply automatic formatting to a date+time value added through an external script. I have a CRM integrated with ...
1
vote
1answer
29 views

Format Google Analytics Date

I'm using the following formula to retrieve week day and day from a Google Analytics report in Google Spreadsheet: =CONCATENATE(CHOOSE(WEEKDAY('90diaspessoas'!A16),"Domingo","Segunda","Terça","Quarta"...
1
vote
0answers
23 views

Referring to another workbook in Excel Online

I'm trying to do a COUNTIF in Excel Online that counts the number of times a word appears in another workbook in Excel Online. Unfortunately, this doesn't seem to work the same way in Excel Online as ...
1
vote
0answers
422 views

Strange language settings in Excel Online

I've a personal Office account, and using Excel Online I've realized that the language of OneDrive and Excel is English, and I see everything in English, except formulas. When I type formulas I get ...
0
votes
1answer
61 views

Hide the contents filled by each anonymous user on Excel Online

In order to fill a spreadsheet, I need ask to 50 people to fill it using Excel Online. Each person must fill a column in the spreadsheet. After that, when he quits the document, is there any ...
2
votes
0answers
446 views

How do I move a picture behind text in Excel header?

When you insert a header into Excel you get three bars to work with; left, middle and right. I wish to insert a banner picture into the middle bar and the text shown is: &[Picture] In the left ...
4
votes
3answers
11k views

Is it possible to set up conditional formats using Excel Online?

Is it possible to set up conditional formats using Excel Online? The cell's context menu doesn't have the option, and I can't find it in the ribbon either.
3
votes
1answer
427 views

Using an Excel survey in Office 365 for business

A instructor in our community college is trying to create a survey using Office 365. The link https://support.office.com/en-us/article/Surveys-in-Excel-hosted-online-5fafd054-19f8-474c-97ec-...
1
vote
1answer
687 views

Different permission for different user on Excel Online

I need to create Excel on-line workbook with different permissions sheets. more like some users can see some sheets while other can't edit, etc. can I achieve this?
0
votes
1answer
4k views

Filtering doesn't work right in Excel online

The filter function in the Excel web app simply doesn't work. Here I'm choosing to show all statuses except Done, and it shows it anyway: There actually are some rows with a status of Done that are ...
4
votes
3answers
9k views

How to import a csv file into Excel on Microsoft Office Live

I'm working with Moodle to export a csv file. The file is encoded as UTF-8 but Excel doesn't recognise it and so displays odd characters. I've modified the code to insert a BOM as per https://...
4
votes
1answer
10k views

Does Excel Online support filtering columns by value?

One of our customers shared to us an Excel Online document for exchanging notes and bug reports, the file is starting to grow quite a bit, and could benefit from filtering: one of the columns ...
-1
votes
1answer
1k views

Embed Google / Microsoft Excel spreadsheet [closed]

I'm searching for few hours for a web app which allows me to create a spreadsheet and embed in to my webpage. I've looked through Microsoft Excel web app and Google spreadsheets, but none of them ...