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

I have a client with 5 Users they are using POP for email as the budget does not allow for a full Exhange/AD install.

What is the simplest way to have them all have a calendar they can all share, edit and see full details of any meetings/appointments made by the other users?

They are all using Win7PRO/Outlook 2010.
Started last week for this user cant see any rime or reason some emails some do not.  Immediately returns email found answers about contact list deleted contacts readded them
Outlook 2010 pop3 server

Message-ID: <003601cf89a6$d9b0c1d0$8d124570$>
MIME-Version: 1.0
Content-Type: multipart/alternative;
X-Mailer: Microsoft Outlook 14.0
Thread-Index: Ac+Jptj+c/yh7+LyTC6RHfVRYJWHgg==
Content-Language: en-us

This is a multipart message in MIME format.

Content-Type: text/plain;
Content-Transfer-Encoding: 7bit


Content-Type: text/html;
Content-Transfer-Encoding: quoted-printable

<html xmlns:v=3D"urn:schemas-microsoft-com:vml" = xmlns:o=3D"urn:schemas-microsoft-com:office:office" = xmlns:w=3D"urn:schemas-microsoft-com:office:word" = xmlns:m=3D"" = xmlns=3D""><head><META = HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Dus-ascii"><meta name=3DGenerator content=3D"Microsoft Word 14 = (filtered medium)"><style><!--
/* Font Definitions */
      panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
We have a large number of word docs with common sections, such as dept applications that are shown in a table at the front of the documents. The obvious problem is what to do when the common section is updated on the source template.

I have been playing around with bookmarks and hypertext by pointing them at a template document. That works, but the user has to click through the link to see the detail. I was hoping to find a way to update my target documents dynamically with the detail. My impression is that the only way to manage this is via a macro. Is that accurate?

hi all, can someone please help with a creation of a vbscirpt to automatically send email from outlook every hour?
I received an rar document from someone and after trying at length to open it I was unable to do so and got that person to send me a Word doc instead.  Something shifted and ever since that event when I get an incoming pdf it gives me a black screen and I have to download and then read it.  I was doing just fine with pdf's with no problems before the rar document incident.  It was absolutely tied to that event and I noticed the change immediately.

I need to get rid of the problem and get back to what I had before which worked just fine.
I would like to change the view of my Outlook 2013 contacts so that once a contact has been created whenever I open that contact to view or edit it the contact will look exactly like it did when I first created it (see the first screenshot). In this view all the notes section is at the right hand side off the contact and the spell check (by pressing F7) and auto line numbering work. This was the way that Outlook 2010 worked.

However in Outlook 2013 once a contact is created and then the contact is opened the contact will display in a format that is quite different and where a user has to click on the Notes tab to view and edit the contact's Notes (see the second screenshot). About the only functions that work within the Outlook 2013 notes are cut, copy, and paste. Other functions such as using different fonts and making text bold or italics are unavailable (see the third screenshot).

Several users in my office don't like the new Outlook 2013 contacts format (especially with the notes) and would like to change the Office 2013 contacts so that when an existing contact is opened this contact will display exactly like when it was first created and the way that it would display in Outlook 2010 (see the first screenshot).

How can this be done?

If this is something that can't be changed within Outlook are there any utilities or other methods that can be used to change this?

Editting an existing contact
Outlook 2013 contact format
How can I make it so that certain Microsoft Office settings will remain in place even after that Office application has been closed and opened again?

For example in Excel I often need to search all workbooks in a certain file for a certain word.

This is something that Excel doesn't do by default since by default it will only search within the sheet that you are currently in.

So I will go into the Find function and then I have to change the Within value from Sheet to Workbook.

So how can I make it so that these kinds of custom settings will always remain the default settings whenever I open the Office program?
I'm looking for 2 utilities (if they exist) to load on my computer which is running Windows 8.1.  First, I would like an email notifier which would let me know when mail arrives in either my gmail or Hotmail accounts.  Every program I've found is either loaded with malware and blocked by my antivirus ... or requires that I also load the ASK toolbar and search engine to complete the download ... which I'm not willing to do.
The 2nd program I would like is a desktop calendar which would display the current month.
I don't mind paying for the software if I can find a legitimate vendor.  Can anyone make a recommendation.


What is the best way to associate two Excel workbooks where Spreadsheet A can reference selected lines or fields in Spreadsheet B.  For example: The problem that we have is if Spreadsheet A mentions something on Spreadsheet B as "shown on line 57."  This works ok until someone adds one of more lines above 57.  If a line is added below line 20 then the reference to line 57 will immediately be incorrect because what was on line 57 is now line 58.  Currently, the users of Spreadsheet B must inform the users of Spreadsheet A whenever changes are made that might change what is refereced on any lines of Spreadsheet B so that the references on Spreadsheet A may be updated to the correct references.

I would like for the references in Spreadsheet A to automatically update the reference line number on Spreadsheet B.  Is that possible and "simple" to do?
We need to send fax using  mail merge to multiple people. we have land-line  modem connection with PC. Currently using windows system.

Is there any software that provide this facility ?
I'm working on an application that needs to identify all instances of Excel which are open, and be able to set the reference to the Excel object.

I found some code (slightly modified below) which does a good job of finding all of the instances where there is a workbook open in the instance, but I cannot figure out how to see the reference to an instance that doesn't have a workbook open.
Option Compare Database
Option Explicit
#If VBA7 Then

    Private Declare PtrSafe Function FindWindowEx Lib "USER32" _
    Alias "FindWindowExA" (ByVal hWnd1 As LongPtr, ByVal hWnd2 As LongPtr, _
    ByVal lpsz1 As String, ByVal lpsz2 As String) As LongPtr

    Private Declare Function FindWindowEx Lib "USER32" _
    Alias "FindWindowExA" (ByVal hWnd1 As Longptr, ByVal hWnd2 As Long, _
    ByVal lpsz1 As String, ByVal lpsz2 As String) As Long
#End If
#If VBA7 Then

    Private Declare PtrSafe Function IIDFromString Lib "ole32" _
    (ByVal lpsz As LongPtr, ByRef lpiid As GUID) As LongPtr

    Private Declare Function IIDFromString Lib "ole32" _
    (ByVal lpsz As Long, ByRef lpiid As GUID) As Long

#End If
#If VBA7 Then

    Private Declare PtrSafe Function AccessibleObjectFromWindow Lib "oleacc" _
    (ByVal hWnd As LongPtr, ByVal dwId As Long, ByRef riid As GUID, _
    ByRef ppvObject As Object) As LongPtr
    Private Declare Function AccessibleObjectFromWindow Lib "oleacc" _
    (ByVal hWnd As Long, ByVal dwId As Long, ByRef riid As 

Open in new window

Glenn -

I also received clarity on the Flow Through Expenses for the Forecast piece. There will be one Flow Through Expense Column for each Fiscal year. Flow Through Expenses will take into account all Expenses for a full Fiscal Year in one column for each row.  The only rows which should be included are "nnnn" through rows "hijk". So for example, let's say we are trying to calculate the Fiscal 2015 Flow Through Expenses for Row 21 which is "tttt". Assuming this project starts in Fiscal 2014, we would use the Year 1 number of $130,000. Similarly, if we are calculating the Fiscal 2016 Flow Through Expense for that same Row, we would use the entire Year 2 number of $132,000. In other words, Flow Through Expenses is just calculating one full year of expenses for a certain group of rows (nnnn thru hijk), but it would be using the first year's number to forecast for the year AFTER the project starts.  So, at any point, if I were to select Fiscal 14 in a pivot table, it should have a Flow Through Expense column at the end. The same would go for Fiscal 15, Fiscal 16, etc. Additionally, if I wanted to select a Year 1 view or Year 2 view, it should also show the Flow Through Expenses for each of the views selected.

I'm not sure where the best place to put this column, perhaps after the months? Years?

Let me know if you have any questions about the Flow Through portion, I know it can seem confusing, but it's easier than what I originally thought it was.

Lastly, after we …
Hi Experts,

I am working on a project that requires us to move are current way of connecting to Oracle DB in Excel using an ADODB connection to a web service call.   All of my users are using Excel 2010 or 2013.  So I need to re-right the vba that has the current connection using ADODB to webservice and was wondering if this is possible and if I could see some code if possible.

I am experiencing an issue with Sharepoint through Office 365 and a mapped drive to the content.  When the mapped drive is first added, the drive stays connected for about a week.  After then the connection is lost.  When clicking on the mapped drive I get an error message web client network access denied (attached picture).  I have added the site to the trusted sites before mapping it initially and I know the mapped drive does work.  The only way I was able to fix this without remapping the drive every week is to open sharepoint on the web, browse to folders, and open in explorer.  Once I open the local folder of sharepoint, the mapped drive connection is restored.  Any ideas?
I am trying to create a summary (publishable) worksheet with certain data from a master worksheet.  The master worksheet contains a continually evolving list of products and their scheduled release date.  As products are released to the market, the master worksheet is updated to reflect the actual release date.  

Our business partners are asking us to provide them with periodic updates about upcoming releases, projected release dates and their actual release dates.

As noted above, I would like to create a worksheet (within the same Excel file) that will hold various pieces of information contained on the master file.  I would like the summary worksheet, if possible via formulas or macro(s), to be updated either dynamically or by executing a process.  

The update needs to include product releases that have already been reported (reflecting an updated projected release date, and eventually the actual release date).  It should also include any new entries to the master list.

While some of our products are scheduled within the next 30 - 120 days, some are like 'pie in the sky' products that are on the radar, but with no release date.  Therefore I would like to limit the updates to existing plus the next three months, ignoring anything further out.  In the sample attached, the summary report could only report the month of expected release.  the Expected Submission date sometimes is completed with either an actual date or just the month.  For the purposes of …
I have a query which is summing hours but it is rounding 5 positions to the right of the decimal place.  Is there a way to tell it to round up to the next whole number?  Thanks!
I am using a fomula to write a value I enter in one sheet so it displays on another sheet ='Worksheet1'!E9. The problem is that the value is showing up as ####### becasue the value is too long for the cell that is displaying it; how do I display the value so a person can read it? I don’t want to increase the cell size because I have other cells in the column which require that size.

What am I missing that people want to read ####### I’ve asked people and no one can make any sense of #########. Shouldn't the default be to show the value????

Just need to fix a math operation.  I have a spread sheet with 5 columns. first three col are txt, next two are numeric values.  the data changes daily.  I need to multiple the values in the 4 and 5 columns by -1.
i have :
Sub Multiple()
    Application.ScreenUpdating = False
    Dim i As Long, k As Boolean, rng As Range, wb As Worksheet
    i = 1
    Do Until i > Cells(65536, "c").End(xlUp).Row
       Set rng = Range("c2:c" & i)
          i = i + 1
          If Application.WorksheetFunction.CountIf(rng, Cells(i, "c").Value) = 1 Then
          If Cells(i, "d").Value <> "" Then Cells(i, "d").Value = Cells(i, "d").Value * -1
           If Cells(i, "e").Value <> "" Then Cells(i, "e").Value = Cells(i, "e").Value * -1
              End If

would you please recommend me some of the best tools to convert PDF to XLS? the tool must allow conversion for multiples pdf files in one step. Also, must allow to convert tables from pdf to xls and assign fixed columns in excel for each column in pdf file

best regards
I have four columns of data. Two sets of X,Y coordinates.
X1                      Y1                                  X2                Y2
2893485.397      2159991.701            2893478.343      2159954.687
2893851.974      2159972.248            2893820.917      2159944.458
2894429.356      2159998.628            2894424.336      2159960.635
2895089.535      2159907.211            2895087.666      2159875.504
2895702.349      2159973.445            2895668.207      2159939.631
2896055.331      2159914.853            2896052.252      2159876.48
2896429.074      2160012.72            2896427.449      2159981.793
2896425.664      2160285.545            2896416.933      2160271.983
2896423.336      2160592.846            2896400.906      2160577.979
2893000.438      2160001.187            2892982.095      2159987.436

There's a total of 1200 rows.

I need to know if, for each item described by X1,Y1 there is an item described by X2,Y2 with 30 units in either direction.  Not just the item in the corresponding row, but ANY item.  i.e. within +/- 30 units in the X direction and the Y direction.

This is a bit tricky.
My colleagues and I have developed a document template for our reports.  We have formatted the caption style so that it appears as we wish and almost have the table of figures style as we want, but not quite.

We are used to a tab appearing between "Figure n" and the caption of the figure in the table of figures.  

Instead we get "Figure n" followed by a colon, a space and the caption. This interferes with the clean wrapping of long captions for which we want to use a hanging indent.

I can't find where to modify what appears after the figure number in the table so that I can remove the colon and include a tab.

Can anyone explain how to achieve this?
Looking for some help on creating a formula for Google Spreadsheets.

I have the following cells

        A1                      B1                     C1                     D1
Item                         Cost                   Savings            Cost after savings
Juice                       $1.99                   $0.75               $0.49
Pretzels                  $3.99                  $0.99               $2.01
Plates                     $2.50                   $0.55               $1.50
Cleaner                  $1.99                   $1.00               $0.99

I need a formula that says to only double the value of column C up to $0.99 ($1.98), anything after that is just face value, i.e. $1.00, $1.25, $2.00

In Outlook 2010 I have some generic text I send to people each week. It's a message that has links in it to some help pages on our company intranet. But when I use Quick Steps to create this message, and I copy the text from Word, where the links work perfectly, Quick Steps will keep the text but strip the formatting so I need to keep copying from Word and pasting into the Outlook email in order for the links to stay active. Is there a way to create a Quick Step in Outlook 2010 that will keep the links in tact?

Hi All

What I need to achieve is for a range of cells in Excel is;

Click the cell once, get a check mark, click again, get an X, click again, get a blank.  (single click or double click would be fine)

The check box feature is too messy looking for this form (unless the 'box' can be invisible or white). Do not want to use drop down either.

loosing hair over this .. please help!
I have an Excel spreadsheet file (238 lines long) sample as follows:

Henry Jones      Jack Jones        AAA, Inc.             AAA Auto            123-444-2478       123-444-9774
Frank Smith      Sam Smith       A-1, Inc.              A-1 Auto             123-555-7458       123-555-9004
Henry Jones      Joe Dokes        Best, LLC             Best Auto            123-666-7856       123-666-9974
Frank Smith      Jim Wilson      City, Inc.              City Auto             123-777-7845       123-777-9374
Henry Jones      Bill White        Uptown, LLC       Uptown Auto      123-888-7844       123-888-9484

I need to print 238 fax cover sheet in Word.  I realize I can export the Excel spreadsheet file to and ASCII delimited file but not sure how to proceed in Word.

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.