Microsoft Office

63K

Solutions

41K

Contributors

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Share tech news, updates, or what's on your mind.

Sign up to Post

Word couldn't send mail because of MAPI failure: "Unspecified error".  This error displays when sending an attachment via Word using the File > Save & Send > Send as Attachment.  I have done multiple repairs and uninstall/reinstall, nothing helps.
0
Upgrade your Question Security!
LVL 12
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

We have Office 365 with exchange online and azure active directory. We have enabled and enforced Multi-factor Authentication. We have a handful of users that use Outlook 2016 client on their laptops. For a couple of these users I was unable to setup the account in outlook until I disabled Multi-factor Authentication. After set up I re-enabled it. Now, what seems to be randomly, they will be asked to re-enter the password for the account. When they enter their Office 365 password it is not accepted. If I go in and disable Multi-factor Authentication they can enter their password. Anyone else run into this? How can I enable multi-factor and use Outlook Client reliably?

Thank you for your help!!
0
Export Office 365 Mailbox to PST
In the blog post, we are going to discuss step by step procedures to set up an archive and deletion policy for Office 365 mailboxes.
0
Hi Experts,

Need help to calculate the date and time difference between two date in attached spreed sheet,(Excluding weekends)

I have tired with multiple formulas but now working correctly, please help us,

Thanks!
Time-differnce.xlsx
0
I need to fill a row (cells A4 - J4)  if K4 is not blank. See attached sheet

**Row 15 is how I want the conditional formatting to work.

Need this to work for 2,000 rows.
FILL-IF-NOT-BLANK.xlsx
0
urgently convert CSV to Vcard file, i don't know how to convert maximum data ?
0
Imagine 5 people in a small company.  During their daily work they write notes in a "day book"  aka A4 Diary.   If its a an "order" then it gets punched into the computer, but other notes, quotes, call backs, comments, call notes get put in the paper book.  When someone is on holiday it becomes troublesome to hunt through the info.

The system that records orders does not have any function to take estimates/quotes and convert to orders later.  nor does it record any notes.
They do however have Office 365 Business and Business Premium (mixed).

As every solution has to now include "the cloud" which of the many Microsoft cloud "things" could be used to replace the "paper day book".

My head says just build a quick AccessDB and or use Email but that's what I'm comfortable with.   I'm trying to push my understanding of the modern offerings by Microsoft and wonder if something like Yammer would suit such a small group? (although it doesn't seem to be included in the current business subscription).

A short coming of Yammer seems to be that must send messages to at least one group, not just a single person (unless you switch to private message).  In the paper book people can score through an items, highlight with a colour marker, *** bold something , mark its as -DONE- or other status updates/doodles etc   I'm not sure if those type of "updates" would be so easy to do in the yammer world.  I'm not sure if Yammer is searchable.

Any ideas for an old dog like me or should …
0
Hi all :)

I have a finance user who needs the function of Powerpivot in Excel 2016

We normally buy Home and Business (retail NOT 365)

Is it possible to to install H&B 2016 WITOUHT Excel and then separately install Excel standalone (which has Powerpivot) ??

thanks
Tracy
0
PowerPoint (Mac) How to Expand/Collapse All Sections??

I have a pitch that grows and grows, now with dozens of sections. Sometime, I need them all expanded, like when I want to search on a key word. Other times, I want them closed.

Is there a menu option or keystroke that does this??

Thanks
0
I'd like to format the output to have commas on thousands position.

Here's the formula

"FY-16: " & ThisItem.FY16_AID         Note FY16_AID in table is 355999. Would like to display as 355,999
0
Cloud Class® Course: MCSA MCSE Windows Server 2012
LVL 12
Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

ms access 2007 automation error excel 20116 interface not registered
0
Hello,

I am running Windows 10 with Office 2013 on two computers.  I have a customized Outlook task form.  It has an Outlook View Control (Active X control) in the form.

On computer A, it works fine.  On computer B, I get the error "Error Loading Form. Some of the needed controls may not be registered."  Computer A and computer B have identical Office and Outlook updates, so I'm not sure why I get this error on computer B.  Perhaps it's a registry setting?  I don't know a whole lot about how to manipulate registry settings, so....

Thank you for your help in advance,
Joel
0
I wrote a service.  The service gets data from a database and exports to excel.

Issue I'm having is that the database and application contain the below value:

Humboldt-Universität zu Berlin

However, in excel the value is

Humboldt-Universität zu Berlin

Any idea how to resolve so excel has Humboldt-Universität zu Berlin?
0
Good Afternoon Experts,

I have a basic quotation excel template that I have created and I have attached for your attention.

In principal I am trying to add some functionality to the spreadsheet to make it interactive and strong proof.

On the 1st Worksheet it shows you basic the layout of the quotation...

I would like to be able to create form so that the user can enter the data in the form and it gets entered directly in the template e.g. Company Name, Address, Post Code, Reference,

The item section is next, the user can enter an description about the item but I want to able to have a button so that you add another item or items that follows each other

Item 1
Item 2
Item 3


The other two sections are called 'Special Conditions' & 'Terms & Conditions' - this block of text is standard and it needs to follow on after the items section

Therefore, these two sections are always at the end of the document.

So when the quotation has been completed - I would like a button to validate the quote...

When the button is pressed - creates a record on the second worksheet with the quotation number and other details from the quotation.

When another quotation is started it should automatically increment the quotation number by + 1

I don't know if any of this is possible but I am looking for some help

 
Template attached

Blank-template.xlsm
0
Trying to apply the same formula that has been advised but referencing a different cell. It does not work. Formula needed is in column K in Pivot tab referencing cell C44 in Payment_Model (2) tab.

I might be doing something wrong. Please advise how to fix it. thanks!
0
We have recently migrated to Office 365 E3 for one of our business units.  They have hired someone new who will be working remotely, using their personal laptop.  

I was just informed this user doesn't have an Office package on that machine and therefore can't open the files she is being sent.  I know her O365 license entitles her to install Office on up to 5 devices, so she should be covered to install on her personal machine.

The question I have is what happens when she leaves our employment?  I want to make sure the Office installation is removed as well.  I have found all sorts of documentation on deactivating an O365 account, but nothing on what happens with Office installations associated with that account.  Will disabling her account disable Office and prevent her using it on her laptop?  Do I have to remotely connect to her PC and uninstall?

Would love to hear how others are handling this.
0
Need to identify if info on sheet 'IDs NOT ON SHEET' exist on sheet '2018_04_02 data dump'

I have a list of numbers in column A on sheet 'IDs NOT ON SHEET'
and I want to find out in there is a match to column H on sheet '2018_04_02 data dump'

I would like to have a 'Match' or 'No Match' appear in column D on sheet 'IDs NOT ON SHEET' if there is a match or no match
0
Using C# .NET, I'm looking for a way to convert Excel documents to PDF without using paid third party tools or Office Interop assemblies (free third party tools are ok). This application needs to run on a server, so unmanaged code (i.e, Office Interop) is a big no.

Appreciate any insight about where to begin my research!
0
I have a string of data in Column D.

The format of the data is \\text\text\filename or \\text\text\text\filename.

For example:
\\text\text\text\text\filename1
\\text\text\text\text\text\text\filename2
\\text\text\text\text\text\text\text\filename3
\\text\text\text\text\text\text\text\text\filename4
\\text\text\text\text\text\text\text\text\filename5
\\text\text\text\text\text\text\text\text\filename6
\\text\text\text\text\text\text\text\text\text\filename7
\\text\text\text\text\text\text\text\text\text\filename8
\\text\text\text\text\text\text\text\text\text\filename9
\\text\text\text\text\text\text\text\text\text\filename10

Length of the string is variable and I only want anything from \\ up to the last \ in the string.

Any help would be greatly appreciated.

Thanks,
Sonia
0
Cloud Class® Course: Microsoft Windows 7 Basic
LVL 12
Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

I want to use the Excel 3D map feature to map a bunch of addresses. However the data I have doesn't have the standard zip codes etc. It's based on electoral regions. It's Ireland rather than a standard US map format. I've played around with the custom regions settings but haven't been able to map it. Any pointers would be useful.  I've downloaded a kml file with the details but so far it hasn't worked. Any suggestions.
0
I just got a new Lenovo P71 Laptop, and installed my Microsoft Office 365.  When I went to Outlook, it's a whole new program that I've never seen before.  It seems to be cloud-based.  How can I set up my Outlook with my local PST file ... and my gmail account to download to my Inbox the way I've always done it in the past?

Thanks,

Phil
0
Can Microsoft 365 office 2016 be used to create an Outlook profile on local exchange server (2013)?
0
Hi All,

I am wondering if anyone can explain how to pull data into Excel, using VBA, from a webpage that has 'options' that need to be chosen.  In other words, this is not talking about a static single HTML page (if that is the correct terminology).

I am not talking about any specific webpage, rather I am talking about it in general.

To give two examples, but not wanting to only get an answer for these two:

1) Petrol Prices

This site:

http://www.pricewatch.co.nz/pricewatch.aspx

allows you to get petrol prices in the last 24 hours.

If we ignore the initial requirement to type in the capture (assume I have done that manually),  on the next page you can 'mouse over' various regions, and it shows you the summary data.  How would I tell Excel to pull in, say, 'Auckland' fuel prices?

Alternatively, or even better, as well as, how would I then have Excel enter a suburb in the box, say, 'Newmarket', and pull in that data?


If pricewatch.co.nz is too hard (I have no real idea), then is this one easier?

2)  This site:

GroceryTracker.co.nz

gives you current grocery prices from a range of different retailers around the country.

How do I get Excel VBA to pull in, say:

Region = Auckland
Product Category = Wine



I am hoping for a general answer (I only chose these two sites as they offer constantly changing data sets that are available to …
0
Using C# .NET, I'm looking for a way to convert Excel documents to PDF without using paid third party tools or Office Interop assemblies. This application needs to run on a server, so unmanaged code is a big no.

Appreciate any insight about where to begin my research!
0
Hi,

How can I read stock prices from yahoo finance using VBA? Please point me toward some code to accomplish this.

Thanks
0

Microsoft Office

63K

Solutions

41K

Contributors

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.