Stack Overflow
Stack Overflow

Questions tagged [excel-online]

119 questions
1
vote
2 answers

How to insert static timestamp in Excel Online?

I am working with Excel Online (browser) because I am working with more people. I am trying to create a time stamp in a cell (eg. B1) after I write the value in a diferent cell (eg A1). In the Excel app I could do this with VBA using the Now()…
fr0zt
  • 733
  • 4
  • 12
  • 30
1
vote
0 answers

Macro to Copy from Local Excel and Paste to Excel Online

Please verify if this is possible... I have a team of 5. We each have local excel files we use as project trackers. We want to collaborate on a high level using a master project tracker in Excel Online on OneDrive but individually continue to use…
Steven Gilbert
  • 35
  • 1
  • 2
  • 9
1
vote
0 answers

Excel Online fails to persist CustomXML Parts

I want to persist some data in CustomXMLParts using Office-js Web Addin in Excel. This is working all right in Desktop version of Excel 2016, but does not work on Excel Online. Here are few simple steps to reproduce this issue using ScriptLab Excel…
kudlur
  • 1,215
  • 3
  • 15
  • 23
1
vote
0 answers

Using Ofice-JS outside a taskpane

I have an excel-online iframe embedded workbook that is served through WOPI service to client. I have created a taskpane that auto-loads when you open the document. The taskpane does not open in view-mode but works fine in edit-mode. The goal of…
Boago
  • 131
  • 1
  • 3
1
vote
2 answers

How to run an instance of Excel Online on my own domain?

I stumbled on this website and found it very interesting because I'm trying to do the same thing: run Excel Online on my own domain. I tried Googling around without success. Does anyone have a resource or approach to this problem (see image for more…
user3331671
  • 21
  • 2
1
vote
1 answer

Excel Online OfficeJs diagnostics version incorrect

Why does OfficeJs show a different version number then the Info Screen? This also happens in PowerPoint Online but Word Online seems to be correct.
Baris Bikmaz
  • 401
  • 3
  • 11
0
votes
0 answers

(Office 365 online) How to run add-ins when opening file

I would like to automate code execution when opening the file. It means that I don't want the part "Code" Code part, only the part "Run" like this Run part And if it's possible block access to "Code" part. I've tried to use Office.onReady(() => {});…
iKroZz44
  • 1
0
votes
1 answer

Can't frame https://xxx-my.sharepoint.com because an ancestor violates

I got this error when I tried to (i)frame sharepoint.com : Refused to frame 'https://xxx-my.sharepoint.com/' because an ancestor violates the following Content Security Policy directive: "frame-ancestors 'self' teams.microsoft.com…
iKroZz44
  • 1
0
votes
0 answers

Excel Online - Unable To Refresh and Manipulate a Power BI Data Source Based Off Azure Analysis Service Tabular Cube

I'm am basically trying to work around this limitation by placing a Power BI dataset on top of a Azure Analysis Cube and accessing the data set through excel online. I have a Azure Analysis Service instance with a single cube: It builds fine, I can…
David Rogers
  • 2,601
  • 4
  • 39
  • 84
0
votes
1 answer

Power Automate can't find table in excel: No table was found with the name 'SNOW'

I am creating a POwer Automate flow, which triggers when a file is dropped into a sharepoint folder. It triggers fine - and I'm locating the file from the dropdowns in the "List Rows Present in a Table" action. When it triggers, it errors and says:…
Mark Tait
  • 545
  • 3
  • 12
  • 22
0
votes
0 answers

Submitting Form Data to Excel Online

Is there any way to submit data from my html form to a row in an excel online spreadsheet for free? Any help would be appreciated David I have tried all sorts of methods including combining jotform and zapier, but that doesn't allow enough…
David Chanter
  • 1
0
votes
1 answer

How do I filter out blank rows in Office Script

In Excel online, I am attempting to create an Excel office script to filter out blank rows/records in a worksheet. To achieve this I would like to filter the A column by removing all of the blank cells. In the below code I am attempting to find all…
Impugno
  • 5
  • 4
0
votes
0 answers

How to add more than 50000 record in excel file using microsoft graphapi

I have power automate which is creating excel file and exporting the sql query data into excel file. To export the data, i am using graph api excel connector. The graph api query is failing if file size exceeded 4 MB. How can i export the data using…
Liz
  • 13
  • 3
0
votes
0 answers

How to use the text value of a formula as the name of the tab you try to reference to in another formula?

I have this workbook to make invoices using data from the crm. In one sheet I have all the invoice names with hyperlinks to the respective sheets (sheet for every invoice) called Index. In another sheet i have a summary of all the invoices with…
Lars Van der Drift
  • 1
0
votes
2 answers

Power Automate "Add a row into a table", I am not able to detect my sharepoint excel file however can connect to one drive excel

I am trying to import data from email to SharePoint file however I can perform this action only for my OneDrive excel files, my SharePoint is not getting detected. I can find my SharePoint through other actions like "update file(SharePoint)" or…
Thedal Thedal
  • 1
1 2
3
4 5 6 7 8