if cell A2 is less then 1min, i want B2 cell to reflect as Absent. If A2 cell value is more then/equal to 1min i want B2 cell to reflect as Present.

if cell A2  is less then 1min, i want B2 cell to reflect as Absent. If A2 cell value is more then/equal to 1min i want B2 cell to reflect as Present.

For example:
Column A      Column B
  Time               Status
0:00:00            Absent 
0:01:00            Present


Answer

Hi,

Try this

=IF(A2<TIME(0,1,0),"Absent","Present")

more  www.esoftware-shop.com    office2010 word2010 excel2010 cdkey

After every PC reboot office 2010 keeps asking for the product key.

I am running Win7 home premium and installed Office 2010 professional plus that I purchased via MS HUP.  I downloaded and installed Office 2010 OK, but recently it started asking for the product key every time I reboot my PC, and this last time it accepted the key, but then gave me an error (don't have it available at the moment), and it 'backed out' the changes and kicked me out.




Answer

Does an older version of Microsoft Office coexist on the computer?

If yes then ensure all versions of Microsoft Office are uninstalled except Office 2010 using Programs and Features under Control Panel.

If no other version of Microsoft Office is installed on the computer except Office 2010 then try the following steps:

1.    Open Programs and Features under Control Panel

2.    Right-click on Microsoft Office 2010 > select Change

3.    Select the option to ‘Enter a product key’ > Continue

4.    Enter the Product key to update and close the wizard once the configuration complete

5.    Restart any Office 2010 application to activate

6.    Ensure Office 2010 is activated then close the open windows for the Office 2010 application

more  www.esoftware-shop.com    office2010 word2010 excel2010 cdkey

1406 error during Office 2010 install on Win 7

Honestly I've scoured the web and all the suggested solutions are either vague or inapplicable to me.

If you think it's a permission issue, please tell me step by step exactly what should be done!




Answer

Click on the link below to manually remove the Office files and then try to reinstall it:

http://support.microsoft.com/kb/928218

more  www.esoftware-shop.com    office2010 word2010 excel2010 cdkey

Booklet Printing (word 2010)

I am trying to print a booklet in word 2010 and have inserted a border. I am trying to print it so that the book is "portrait" on a "landscape" paper (so the book looks like an actual book). I have tried printing my document several times and the results have either been

1. the book prints in landscape format (so flips up and down)

2. the book prints in portrait format, as does the content (therefore, 1/4 of the book is cut off).

Any suggestions? I have played around with margin and gutters izes and no results.

Answer

Nm, figure it out.

I went out of booklet printing mode and then back into it and that solved it.

more  www.esoftware-shop.com    office2010 word2010 excel2010 cdkey

Excel 2010 Formula changes or Link changes after installing Excel Security Update

After installing the Excel Security Update MS11-072, I received formula errors in the worksheets. The formula changes or the link changes.


Answer

This happens when the formulas in the worksheet contain references to cells on a workbook that is located on a server or on a different machine. You may also get the following  error message:

The file<file name> may have been changed by another user since you last saved it. In that case, what do you want to do? Save a copy, Overwrite changes.

To read detailed information on this issue and its resolution, please go to this Microsoft knowledge base article:

2625406 – UNC Path Changes after Installing Security Update MS11-072

To resolve this issue, install update 2596596. For more information, click the following article number to view the article in the Microsoft Knowledge Base:

more  www.esoftware-shop.com    office2010 word2010 excel2010 cdkey

Why does Microsoft power Point allways lock up and close? What a pain! Do Mac's have this issue?

Every day when I start using Microsoft Office 2010 Power Point I have issues. The more I am using the program, the more it freezes up. I eventually have to do a repair and it's ok for a while. It's a cycle. I have already uninstalled Microsoft Office 2010 & reinstalled it off the Microsoft Office 2010 disc I ordered last month. I ordered it thinking the online download was not 100%. Nothing has changed. Does anyone have suggestions?

Answer

Follow the steps mentioned below and see if it helps

1.Go to Start -> Computer -> C-Drive -> Program Files ->MS Office -> Office 14 -> Right click on powerpnt.exe-> Properties.

2. Go to Compatibility tab -> Disable “Run this program in compatibility mode for” option -> Apply -> OK.

3. Try opening PowerPoint 2010.

If the above step does not work, try changing the default printer.

 To change the default printer follow the steps:

1. Go to Start -> Device & Printers -> Right Click on Microsoft XPS Document writer or Send to OneNote 2010-> click on “Set as Default printer”.

2. Try opening PowerPoint 2010, if it opens then you have to contact printer manufacturer to install the printer driver updates.

For more information on changing the default printer refer:

http://windows.microsoft.com/en-US/windows-vista/Change-your-default-printer

more   www.esoftware-shop.com    office2010 professional

Here Are The Download Locations for Office 2010 and Office 2007

Applies To: Office | Office 2010 | Installing and Activating Microsoft Office Products | Other/Unknown

Microsoft Office 2010 Download Locations

A.  Full Retail (FPP):  http://office.microsoft.com/en-us/products/microsoft-office-2010-backup-FX101853122.aspx

B.  Product Key Card (PKC):  http://office.microsoft.com/en-us/buy/using-the-product-key-card-FX101853163.aspx

Microsoft Office 2007 Download Locations

A.  Full Retail (FPP):  http://www.microsoft.com/office/downloads/

B.  Medialess Licensing Kit (MLK):  http://trial.trymicrosoftoffice.com/msft-orpc/  (corrected link on 5/4/11)

Volume Licensing Customers:

Products are downloadable at the Volume Licensing Service Center: https://www.microsoft.com/licensing/servicecenter/home.aspx

Answer

Some other useful Office links:

Office 2010 trial Versions:

http://office.microsoft.com/en-us/try/

Buy Office 2010 Retail Versions:

http://office.microsoft.com/en-us/buy/

How to order a replacement CD/DVD:

http://support.microsoft.com/kb/302822

more  www.esoftware-shop.com  office2010