Office Productivity

Office Productivity refers both to the act of being productive and efficient in an office or professional environment, as well as the software applications used to "produce" information. This includes the development of professional skills, creating work processes, and almost any program used to create or modify a document, image, audio or video clip. However, business application suites such as Microsoft Office, which include word processing, spreadsheet and presentation programs, are typically called productivity software, as contrasted with a "utility program," such as a file manager, which is used to organize files and folders on the computer. Many office- and business-oriented groups of programs are organized into suites.

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

Sign up to Post

Hi ,

When I try to Save word file as doc instead of docx , that contain many items and graphics I get alert on number of Occurrences which required to be converted.

Before the word convert them automatically to be compatible I would like to see this  occurrences , is there any way to do that ?
0
how to recover pst password
0
1. for ActiveX :Enable all controls without restrictions and without prompting (not recommended; potentially dangerous controls can run)
2. for Macro's :Enable all macro's (not recommended; potentially dangerous code can run)
0
I exported my work mailbox to a PST.  It was 6GB and contained contacts, calendar items and mail items from 2012-2016 and was around 80,000 mail items.  The inbox is about 3.2GB and Sent Items is about 2GB (when I right click and view the Folder Size).  I exported the entire Mailbox (twice) to two separate files so I am certain the file is not corrupted.  Not password protected.

I have copied the PST to my laptop hard drive and added it under Account Settings as an additional Data File.  It shows in the pane on the left as a new mailbox called "Outlook Data File".  However, when I click on Inbox or Sent, the oldest email is only Sept 2015, which means it's missing over 2 years of emails.  I have confirmed that my Calendar items date back to 2012 and so do my contacts.  But my email item count in my Inbox is only about 17,000.  It should be double that.

As a sanity check:  Around mid-2015, I set up Outlook on my home computer and told it to DOWNLOAD all of my emails as an OST and the OST was around 5GB.  I verified that I had year 2012+ emails at that time which tells me the 6GB export I recently did should no doubt include ALL of the emails that I had.

Am I doing something wrong?  Is Outlook somehow archiving this old email or suppressing it in some way?
0
hi Excel Folks

please see attached the example spreadsheet for two  basic project management sheets with raw data in Sheet 1 and Pivot Table in Sheet 2.

I would like to see projects detail per each PM, so I have used a Pivot Table to generate that view as well as summarised budget and cost at left, but then I want to see the other project details at right. but for all fields in the Pivot Table, Excel must choose a way to summarise them even for fields not applicable in logic, such as description, start date, close date etc.

currently for illustration purpose, I manually put the column names at right and they are not part of the Pivot Table.

how can I generate a single table containing all the info (views) i need?

thanks heaps
bbao
my_projects.xlsx
0
in our school they want to give out some pens for Universal Children's Day and they want a tag on each pen

on one side with the school logo which is BWSS (see attached) and the other side is Happy Children's Day 2016 Can anyone do something like this....you might know how to do this cause it has to print front and back and i think is for like 700 kids

I have never used Publisher before
bwss.jpg
0
Can any of you share with me any experience in deployment of the subject technology?
0
What tool can I use for free or for low cost?

I need a PowerPoint alternative.

It's $99/year for home and I have no idea how much for business. This is way too much money for me.

What options do I have?

Thanks
1
Hi Experts,

many users from us have problems with this addin : EUROTOOL.xlam
Is it possible to unistall it ?
If yes can you show me how ?
0
The attached/embedded .GIF shows HOME tab page of Visio 2013. On LHS there is a Custom button added via Ribbon XML. It is compared with a built-in Button supertip (RHS).

This shows (LHS) supertip for Custom button, and (RHS) supertip for built-in button
The supertip text for the Custom Button has extra text I dont require (contains file name and 'Tell me more'). Both these texts hyperlink to Visio help, which I dont require.

Can I disable this extra text? Is it a quirk of Visio 2013? Does this extra text also occur in Visio 2016 (which I'm thinking of acquiring)?

Thanks
Kelvin

(PS If Scott Helmers reads this, I AM working on my projected piece re Visio Comments as discussed this July. It should see the light of day v soon..apologies..
0
I have created a mail merge for labels and it works just fine but there is one field where I only want to grab part of the text. Most wording in this field reads like this for example:  John Doe vs. Microsoft.  I would like to grab only the text before the vs.  In other words I only want to grab John Doe

Can this be done?

The reason I want to do this is because the line becomes too long and it moves to the next line. If I can't do the above, is there a way to automatically shrink the text so it all stays on one line?

Hope that all makes sense.
0
I have extensive code that creates reports in EXCEL from SQL DATA.

I have a VB.NET program that calls the sheet.

    Public Sub doit()
        Dim xlApp As New Excel.Application
        Dim xlWorkBook As Excel.Workbook = Nothing 'New Excel.Workbook
        xlWorkBook = xlApp.Workbooks.Open(My.Settings.ROBSUtility)
        xlApp.Visible = True
        xlApp.Run("printAutoRobs", cmbPrinter.Text)
        xlApp.Visible = False
        xlWorkBook.Close(False)
        xlApp.Quit()

        releaseObject(xlApp)
        releaseObject(xlWorkBook)
    End Sub

Open in new window


The code 'printAutoRobs' worked fine last week, and still works fine in  EXCEL 2013 and down on other PC's... so far...

On PC with EXCEL 2016, It launches and begins to execute, but fails when the embedded EXCEL VBA attempts to rename sheet. With the VBA code paused I can't manually rename the sheet either. If I stop the VBA the sheet will rename normally.

The workbook executes properly on that PC, if i launch it normallly and trigger event. Only during automation is the unwanted behaviour exibited.

basically the code in excel does this

make report in template sheet.
copy template sheet
rename copied sheet (code crashes on rename- tried not renaming see below)
add new sheet to array of sheet names
loop til done
print array of sheets to printer designated
delete sheets created during reporting (code crashes here as well - if i just let excel name them above)





I dorked with trust and macro and certificate but still no love...

Any thoughts?
0
Hi,

Sometimes when I want to send out a meeting invite in Outlook, when I click „Send“, I get an error message and  I am not able to send the invite: See picture attached.

Can you help?
Outlook-2010-Error-message.JPG
0
when going to upgrade office 2010 to office 2016 , in a corporate , what features will be changed
 what are differences between office 2016 and office 2010
 has office 2016 any issues ?
0
I have a client who is going to use Microsoft Project to mostly design Gantt charts, assign people to tasks, the basic things.  I have no experience with Project at all, so I'm wondering if someone could provide answers to the following:

They run Server 2012 R2 on site and do not use Sharepoint. They'll store project files on a shared folder on the server.  They want multiple users to have access to the project files, but it is not necessary that more than one person access the files simultaneously.

If they get Microsoft Office 2016 Standard, is there anything useful in particular that they won't be able to do that most find important?
0
We have a decent size business and the "Operations" people are dead set on keeping thier "SOP" folder.  Just a file share with documents....  it's a complete mess, A mix of documentation/instructions, templates/forms, etc, etc and tons of junk files and mess gets put there, and by thier own admission thier employees dont use it right.

Im trying to point out how a wiki Or combination of wiki and cloud storage like Drive or box) is not just a different location... it's different tools.... there are better capabilities.  It's more easily searchable, you can hotlink, you can have revisions autosaved, etc.

One person in particular seems completely ignorant of the idea that better tools can make doing things less cumbersome and make people more likely to do it/use them....

Anyway - curious if there are any studies or any open business cases out there for how cloud productivity tools can help businesses.
0
We have a page full of images and want to export them individually to a folder.  What is the best way to do this?
0
Hello,

In Word 2013, we needed to have numbered outline lists be different than the default 1)> a)> i> etc.  So we created the all decimal system of 1> 1.1> 1.1.1, etc that works really well.  The problem is that after making an outline and then changing some text formatting such as adding font colors or bold formatting, if I indent or outdent the item, it looses the formatting.  I have attached the sample document.

To replicate the issue:
1) On line "1.1", put cursor at the beginning of the text, and press TAB to indent.  The numbering changes to 1.1.1, but all the formatting is gone (paragraph color, bold/green text), except the highlighted yellow text stays?  Press Shift-TAB and the numbering changes to 1.1, but the formatting is still gone.  How can we retain all the formatting?  I only want the outline (Styles?) process to add the numbering system, and leave the text as it was?

2) Odd: on the very last item "1.1.1.1.1.1.1.1.1" and "1.1.1.1.1.1.1.1.2".  You cannot press TAB to indent since Word will not indent any further.  On "1.1.1.1.1.1.1.1.1", if you Shift-TAB, it will outdent one level, and loose formatting.  BUT on "1.1.1.1.1.1.1.1.2", if you outdent, it keeps all the formatting except for the paragraph color.  And continuing to outdent and indent keeps the formatting.  These are using the same 'Style' settings right?

Thanks!
2016-10-14---EE-Example-TOC-1.1.1.1.docx
0
Hello

We are having an issue with Excel crashing in our Citrix environment, We have captured a dump file but it is saying the symbols are missing.

Where can we find these symbols.
0
I have a sheet with loads columns, and I have just noticed, in all the cells of data - all the cell have endless trailing spaces. I had been creating new columns aside of each of the original columns, and using =trim(A2) to get rid of them, but its taking a long time to complete. Can anyone think of a quick way to remove all trailing spaces on all columns in the report in one single go? Or is my current technique the only way possible.
0
I pay $26/month for a license to use Adobe Acrobat, which I hate.

What free options are there?

I need high confidence the outputted PDF is in the perfect format, however.

Thanks
0
They called me frantic - they had a bunch of emails in their inbox for their POP3 mail that they were saving and now (as of this morning) they are gone (they said they had 'loads' of emails and now only 14.  

The missing emails were as current as today and others were months old.

There's no filter applied (at least no 'filter applied' message at the bottom of the screen.

Yeah, they could have dragged a bunch into another folder. but there's no easy way to see files that were moved / deleted today / get things that were in the inbox back in there, right?

They don't have backups.  Previous versions for their appdata/microsoft/outlook folder  has only 1 previous version from this afternoon when I looked late this afternoon.

any thoughts?
0
I have been running CALC via OpenOffice and LibreOffice for a few years. I do hit problems sometimes with one or other of them but usually they work all right.
I have tried to standardise on OpenOffice.
In the last few days I have been almost unable to open files.  The icon in the task bar sometimes get stuck in an incomplete state with just a blue line at the bottom, and a grey body. I have found sometimes that if I just leave it, it does open after 40 minutes or so. I cannot work with my files like this.
This happens whether the file is .ods or .xls.
I am on windows 10 and I did a system restore which set the system back to where it was before the lastest W10 update, and prior to a 7zip upgrade.
When I restarted the computer it immediately loaded the latest Windows 10 update and did not cure the problem.
I removed the profile file in OpenOffice and this was regenerated automatically when I reloaded.
I also reinstalled OpenOffice.
None of these actions made any change.
Please suggest what the cause might be.
0
Hello
We a have existing team inbox that’s going to get merged into a main team inbox. We all have outlook 2016. What ideas or features we can use to assign emails to all the members of that newly combined inbox- - like flagging, or tagging? Etc – that new main inbox will be managed by multiple people…

Please give me some suggestions how I can use the new/existing outlook 2016 features to organize the emails within it……like a new email comes it, it could be tagged or assigned to a person…. any ideas on How to organize the emails to the target person within the inbox? Using anything within outlook 2016  - so that managing the multiple emails to specific individuals becomes very easy, not a headache

Thank you
0
please in where i found it

like an envelope for the email  like a little phone for the phone, how to find the correct icone for the company web page for add in the signature.
regards
edo
0

Office Productivity

Office Productivity refers both to the act of being productive and efficient in an office or professional environment, as well as the software applications used to "produce" information. This includes the development of professional skills, creating work processes, and almost any program used to create or modify a document, image, audio or video clip. However, business application suites such as Microsoft Office, which include word processing, spreadsheet and presentation programs, are typically called productivity software, as contrasted with a "utility program," such as a file manager, which is used to organize files and folders on the computer. Many office- and business-oriented groups of programs are organized into suites.