Microsoft Office

Microsoft Office questions? Ask an IT Expert for support ASAP

Ask a Computer Expert,
Get an Answer ASAP!

I have a website www.parametricfinance.com where I have

Customer Question
Hi, I have a...

Hi, I have a website www.parametricfinance.com where I have embedded various excel based applications. I have done this using Javascript code obtained via Excel Online for workbooks stored on personal OneDrive (apparently the business version wouldn't permit this). See this article for the process i used: https://support.office.com/en-us/article/Share-it-Embed-an-Excel-workbook-on-your-web-page-or-blog-from-OneDrive-804e1845-5662-487e-9b38-f96307144081?ui=en-US&rs=en-US&ad=US. This worked great until last week. I created a new Excel Workbook, followed the process above, but then found the Javascript tab was NOT there, only the Embed code for iframes. The problem with this is that i programmatically hide the taskbar (using Java code) that Microsoft automatically displays, which enables users to download the excel file (which i don't want). So my question is this: Has Microsoft done away with the Javascript option for embedding in html elements (in an effort to thwart efforts to hide their branding stuff)? If so, is there a way to obtain the fileToken so that the Excel online workbook can be accessed anyway?

Technician's Assistant: What programs and versions are you using?

Using the latest stuff: Office 365, premium/small business version. The website is Wordpress, Excel is presumably 2016?

Technician's Assistant: What is your ideal outcome? How can we solve this for you?

I want to be able to obtain the Javascript for my Excel workbook stored on OneDrive, as i had been able to previously.

Technician's Assistant: Anything else you want the programmer to know before I connect you?

No i think that captures it.

Submitted: 8 months ago.Category: Microsoft Office
Show More
Show Less
Ask Your Own Microsoft Office Question
Customer reply replied 8 months ago
I have added 3 pictures to demonstrate. In picture #1, you can see i have right-clicked on the file that i want to embed. The 3rd option from the bottom is 'Embed'. If I click it, will generate a code and give me the option to 'Customize how this embedded workbook will appear to others' - see right/bottom of picture #2. If i click on the 'Customize how this embedded workbook will appear to others' it will bring me to what is shown in picture #3. Down at the bottom, you will see "Embed code", which is just an iframe code. There used to be a Javascript option by clicking on a Javascript tab to the right of the Embed code tab. If you go to the link that i provided in the original question, you will see what i mean (in the last picture at the bottom of the webpage). That Javascript option does not appear to me now, but i need to obtain the Javascript code for the customized appearance, so that i can embed the appropriate content on the website. Help.
Answered in 2 hours by:
10/4/2017
Microsoft Office Technician: caraleneK, Office Engineer replied 8 months ago
caraleneK
caraleneK, Office Engineer
Category: Microsoft Office
Satisfied Customers: 820
Experience: Office assisters to you
Verified

Hi my name is ***** ***** I will be the expert working with you today to help and resolve the problem you have posted.

in OneDrive, right-click the workbook, and then click Embed. Please see if you have this option or can I log on to have a look at this problem for you.

First, stored your workbook in OneDrive Then, copy the embed code:

In OneDrive, right-click the workbook, and then click Embed

Click Generate, and then click Customize how this embedded workbook will appear to others.

In the What to show box, click what you want to show in your blog. Show the entire workbook, or show a chart, a named range, PivotTable, or table. For information about named ranges and named items in Excel

In the Appearance section, check the boxes for the options you want

Waiting for your feedback or a rating.

Ask Your Own Microsoft Office Question
Customer reply replied 8 months ago
Hi Caralene, that did not solve my problem. Everything you described, I already have done and knew how to do, as you can see from the content of my questions and the pictures i uploaded for each step. What i need you to tell me is how to access that Javascript option (typically accessed by clicking on a 'Javascript' tab to the right of the 'Embed code' tab). This code is found at the bottom of everything you reference. If you go see my pictures and/or try it out on your own, you will see that the 'Javascript' option does not appear. This is what i need help accessing. Thanks.
Microsoft Office Technician: caraleneK, Office Engineer replied 8 months ago

Thanks a lot for this info. This look like a problem with Microsoft.

Please tested your own workbook by logging in to my Microsoft OneDrive account (i.e. the Microsoft account that is separate from O365 for business. I accessed OneDrive by going through onedrive.live.com, and not office.com). When you uploaded your Excel workbook to onedrive.live, selecting the workbook and see if it brings up an embed code icon.

Waiting for your feedback

Ask Your Own Microsoft Office Question
Microsoft Office Technician: caraleneK, Office Engineer replied 8 months ago

Thanks I sure you know this I just need to confirm.

To work programmatically with an embedded workbook, you must do two things: store the Excel workbook on OneDrive; and insert ECMAScript (JavaScript, JScript) code into the web page to programmatically embed the workbook.

Store the workbook on OneDrive Before you can embed a workbook on your web page the workbook must be available to view publicly. The workbook must be shared to the public from OneDrive.To display and programmatically work with the workbook on a host web page, you must create and insert embed code into the HTML of the host web page. The embed code defines a <div> element, includes a reference to the Excel ServicesECMAScript (JavaScript, JScript) library, specifies the workbook (or chart, named object, or range) to embed within the <div> element, specifies various options for the display and interactivity of the workbook, and then embeds the workbook.I know Microsoft done changes.

Waiting for your feedback

Ask Your Own Microsoft Office Question
Customer reply replied 8 months ago
I believe that I have done all that you describe. I have been able to do this successfully up until this week. You can see on www.parametricfinance.com an example of javascript in an HTML element on the webpage. Today, we are simply trying to follow the exact same process again, but we are not able to get the Javascript code to the OneDrive file. Do you want me to attach a txt file of the Javascript that is in the website?
Microsoft Office Technician: caraleneK, Office Engineer replied 8 months ago

Yes please attach a txt file. Also look at this plz

After you've set sharing to "Everyone", click "Get link." The link that I get looks something like this: "https://hostprovidername-my.sharepoint.com/personal/myname/....guestaccess.aspx?docid=23kj4hkjbs876...&authkey=SIdslbxxoIL2jd8s"

Switch out "guestaccess" with "WopiFrame", and try the embed again. It should be available to the public now and parameters will work.

There's a different docid that is generated if you get the pre-generated embed code. It defaults to WopiFrame.aspx, but the query after it will look like this: "WopiFrame.aspx?sourcedoc={3jf890d-0s9d-298d-d9x0-9d9s87c7shdf}" This will not allow public access without signing in.

Ask Your Own Microsoft Office Question
Customer reply replied 8 months ago
Here is the Javascript. I have never had to do anything that you describe. Has something changed?
Microsoft Office Technician: caraleneK, Office Engineer replied 8 months ago

Yes I see a lots of people complain about the same problem. Let me look at this.

Ask Your Own Microsoft Office Question
Microsoft Office Technician: caraleneK, Office Engineer replied 8 months ago

Everything look good from your txt.Also just have a look at this setup please

https://community.canvaslms.com/groups/designers/blog/2015/04/28/embedding-onedrive-documents-in-canvas

Ask Your Own Microsoft Office Question
Microsoft Office Technician: caraleneK, Office Engineer replied 8 months ago

Have you done updates in the last week ???

Ask Your Own Microsoft Office Question
Customer reply replied 8 months ago
I do not understand any of this:
"After you've set sharing to "Everyone", click "Get link." The link that I get looks something like this: "https://hostprovidername-my.sh…....guestaccess.aspx?docid=23kj4hkjbs876...&authkey=SIdslbxxoIL2jd8s"Switch out "guestaccess" with "WopiFrame", and try the embed again. It should be available to the public now and parameters will work.There's a different docid that is generated if you get the pre-generated embed code. It defaults to WopiFrame.aspx, but the query after it will look like this: "WopiFrame.aspx?sourcedoc={3jf890d-0s9d-298d-d9x0-9d9s87c7shdf}" This will not allow public access without signing in."I went to you canvas link. I have seen that path to getting a html code. but not that it is an iframe, not javascript.I don't feel like i'm making any progress at all.
Customer reply replied 8 months ago
I don't know how to set the sharing to "Everyone" can you explain? I don't see that setting anywhere. LIke i have said, these files, i could get javascript for them until this week, i have changed nothing.
Microsoft Office Technician: caraleneK, Office Engineer replied 8 months ago

sorry I just need to confirm all this I sure you done it all but something changes.

I will opt out let see if somebody ells can assist

Ask Your Own Microsoft Office Question
Customer reply replied 8 months ago
ok, am i now waiting for another expert to take over?
Microsoft Office Technician: George Sibiya, Computer Hardware Engineer replied 8 months ago
George Sibiya
George Sibiya, Computer Hardware Engineer
Category: Microsoft Office
Satisfied Customers: 358
Experience: PhD in Computer Science
Verified

Hi,
Welcome to JustAnswer and thank you for utilising our services

From your discussion above it appears some unannounced changes might have occurred.

I'll just do a quick investigation to see if there cannot be a workaround to your issue

Regards,

G

Ask Your Own Microsoft Office Question
Customer reply replied 8 months ago
ok, how long do you think it will take?
Microsoft Office Technician: George Sibiya, Computer Hardware Engineer replied 8 months ago

Alright, there appears to be no word about it but the Java Script tab is definitely no longer there

Please check the following, its from a while back but it might still work and you would still have full control of the JS code:

http://www.jkp-ads.com/Articles/embeddedexcel02.asp?AllComments=True

Ask Your Own Microsoft Office Question
Customer reply replied 8 months ago
The following line of javascript is the connection to the spreadsheet: "var fileToken = "SDD4FC11B4649848DA!1665/-3099582977058256678/t=0&s=0&v=!ADUXSY2dVhYQPdI";"After the last "=!" appears to be a unique reference code/number. Where can i find it? The above link no longer works.
Customer reply replied 8 months ago
Basically,how does one find the fileToken to enter into a javascript code for the HTML element to accdess the Excel online workbook?
Customer reply replied 8 months ago
also, interestingly, as the page loads that allows customization and the embed code, you can momentarily see the Javascript tab pop up before it disappears. If you refresh the page, you can again see the Javascript tab. But it does not stay and provide the code.
Customer reply replied 8 months ago
Do you have a line into Microsoft to find out what happened to the JavaScript tab shown in:
https://msdn.microsoft.com/en-us/library/hh315812.aspx?
Microsoft Office Technician: George Sibiya, Computer Hardware Engineer replied 8 months ago

There appears to be an error on the site when opening the embed dialog, please attached.

Issues can be reported on the forum here: https://social.msdn.microsoft.com/forums/en-us/home

Under normal circumstances, the token can be seen on the JavaScript code which we cannot see at the moment.

There is just a lot of information on how to use the token but how to obtain it.

I'll update you when I come across new info on this issue.

Ask Your Own Microsoft Office Question
Was this answer helpful?

How JustAnswer works

step-image
Describe your issueThe assistant will guide you
step-image
Chat 1:1 with a microsoft office technicianLicensed Experts are available 24/7
step-image
100% satisfaction guaranteeGet all the answers you need
Ask George Sibiya Your Own Question
George Sibiya
George Sibiya
George Sibiya, Computer Hardware Engineer
Category: Microsoft Office
Satisfied Customers: 358
358 Satisfied Customers
Experience: PhD in Computer Science

George Sibiya is online now

A new question is answered every 9 seconds

How JustAnswer works:

  • Ask an ExpertExperts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional AnswerVia email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction GuaranteeRate the answer you receive.

JustAnswer in the News:

Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.

What Customers are Saying:

My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed.

One Happy CustomerNew York

Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help.

Mary C.Freshfield, Liverpool, UK

This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!!

AlexLos Angeles, CA

Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult.

GPHesperia, CA

I couldn't be more satisfied! This is the site I will always come to when I need a second opinion.

JustinKernersville, NC

Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around.

EstherWoodstock, NY

Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know.

RobinElkton, Maryland

< Previous | Next >

Meet the Experts:

jstinehelfer

jstinehelfer

Information Systems Manager

36 satisfied customers

A+ Comptia Certified computer repair

JasonJames122

JasonJames122

Computer Enthusiast

0 satisfied customers

I manage all information systems (network of Windows PC's and servers with Microsoft Office products) for a small business

Jess M.

Jess M.

Computer Support Specialist

842 satisfied customers

Computer Software Specialist for more than 10 years

The-PC-Guy

The-PC-Guy

Computer Manager

653 satisfied customers

20 years experience providing remote computer support

James K.

James K.

Consultant

260 satisfied customers

Technical Director of IT Company

Kamil Anwar

Kamil Anwar

Office Specialist

219 satisfied customers

8+ Years of Experience. / CCNA (S), CCNA (W), CCNA (RS), MCTS, MBCs.

IT Miro

IT Miro

Computer Scientist

160 satisfied customers

Bachelor's Degree in Information Technology, Microsoft Certified Professional

< Previous | Next >

Related Microsoft Office Questions
I keep getting phone calls that my Microsoft program will be
I keep getting phone calls that my Microsoft program will be turned off. I am very suspicious of any unsolicited phone calls. Can you help me confirm is this is legitimate … read more
Jess M.
Jess M.
Computer Support Specialist
Bachelor's Degree
842 satisfied customers
I have a formula that calculates total time worked, and I
I have a formula that calculates total time worked, and I put "X"s in when they are not. the formula does not register the "X"s and it appears in the formula box as #VALUE! How do I get the X's to not… read more
Jess M.
Jess M.
Computer Support Specialist
Bachelor's Degree
842 satisfied customers
I have a problem with my Word program. Someway somehow every
I have a problem with my Word program. Someway somehow every time I open a new document on Word to do a letter or any kind of document the cursor starts at the very top of the page even though I alrea… read more
Viet - Computer Tech
Viet - Computer Tech
Computer Technican
Bachelor\u0027s Degree
969 satisfied customers
I am having problems with my office words and i seem to get
i am having problems with my office words and i seem to get half pictures when i do insert … read more
Mr.Med
Mr.Med
1,153 satisfied customers
Cannot sync office calendar with my I pad. Windows 10. Only
only recently all of a sudden I have 3 different calendars on my pc … read more
bbao
bbao
Freelance IT Consultant
74 satisfied customers
I'm having trouble with excel. I rent my office suite so I
I rent my office suite so I think it updates every month. … read more
bbao
bbao
Freelance IT Consultant
74 satisfied customers
Publisher has detected a problem and to protect my computer
Publisher has detected a problem and to protect my computer will not open the file … read more
Richard
Richard
IT Manager
IT Manager, Consultant
3,439 satisfied customers
Have been expecting a booked call for 12h00 (South African
Good morning My name is***** and have been expecting a booked call for 12h00 (South African time) for help with my computer. I have a case of(###) ###-#### Neither Rudolf, Joseph or Jobelle were able … read more
bbao
bbao
Freelance IT Consultant
74 satisfied customers
I accidentally removed my Microsoft office program, the
I accidentally removed my Microsoft office program, the program was already down loaded on the computer when I purchased it. Would it be possible to get Microsoft to assist me in another download. it … read more
John
John
System/Network administrator
High School or GED
2,073 satisfied customers
Why are my printed pages blank when the document is not? I
why are my printed pages blank when the document is not? … read more
Shefin
Shefin
Technical Support Executive
Engineering Diploma
222 satisfied customers
My microsoft office was accidentally deleted from my imac.
my microsoft office was accidentally deleted from my imac. how do i get it back? … read more
William Harder
William Harder
SR Sytems Engineer
Technical School
49 satisfied customers
I just migrated all my files from a broken MacBook Air to t
Hi, I just migrated all my files from a broken MacBook Air to t anew one, same model but 2017 instead of 2015. Excel won't open now, what can I do? … read more
John Castle
John Castle
BSC in Computing Network Management and Design
75 satisfied customers
Yesterday I purchased office 365. it will not completely
yesterday I purchased office 365. it will not completely download. as a result, i am unable to use excel. please help. … read more
Mike Taylor
Mike Taylor
44 satisfied customers
Help, I need to replace Vista with Windows 7 and cannot find
Help, I need to replace Vista with Windows 7 and cannot find it on site … read more
Cody
Cody
Computer Science
2,371 satisfied customers
I paid for Microsoft Office yesterday, How can I activate
I paid for Microsoft Office yesterday, How can I activate it? Richard Cashman … read more
Byron
Byron
IT Support Specialist
Bachelor\u0027s Degree
410 satisfied customers
I can't install my office 365. HELP! Office 365
I can't install my office 365. HELP! JA: What application are you using? Customer: office 365 JA: Have you installed any updates recently? Customer: no JA: Anything else you want the Microsoft Office … read more
ChrisC
ChrisC
PC Technician
Associate Degree
661 satisfied customers
Everytime I type in a formula in Excel, the program quits.
Everytime I type in a formula in Excel, the program quits. It has worked fine until now … read more
John Castle
John Castle
BSC in Computing Network Management and Design
75 satisfied customers
I have 365 on my other computer but want to install it on
I have 365 on my other computer but want to install it on this one. How do I do that ? … read more
William Harder
William Harder
SR Sytems Engineer
Technical School
49 satisfied customers
Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Show MoreShow Less

Ask Your Question

x