Windows IT Pro is the authoritative and independent resource for windows nt, windows 2000, windows 2003, windows xp. Features a collection of resources and magazines for windows IT professionals.
  
  
  Advanced Search 


February 2007

Getting to Know Office 2007

Answers to your questions about the new Microsoft Office 2007 System
RSS
Subscribe to Windows IT Pro | See More News and Analysis Articles Here | Reprints | Or get the Monthly Online Pass—only $5.95 a month!

Will Microsoft Office 2007 System updates be easier to deploy to users?
Yes. In previous Office versions, you kept local installations current by updating the source files in the administrative installation point and triggering a reinstallation of Office on each user's computer. Or you configured Office 2000 Setup to chain software updates with new installations of Office. Keeping all installations synchronized was difficult.

Now, you create a network installation point that you never have to update, so that client computers never become out of sync with the installation source. Keeping new installations current is as simple as copying updates to a folder on the network installation point. There's no need to configure complex, chained deployments or modify the original installation files.

New installations will chain the updates in sequence, and you can specify different locations for updates by using a config.xml file. (For more information about deployment mechanisms, see the Microsoft article "Deploy the 2007 Office system with limited network capacity" at http://technet2.microsoft.com/office/en-us/ library/1f721083-6d58-4a53-94c1-1bbfc36a249b1033.mspx.)

For organizations that subscribe to Windows Server Update Services (WSUS), I highly recommend that you install Office 2007 with cached installation files and distribute updates by using WSUS.

What can I really expect from Office 2007?
Your users are definitely in for an adjustment as they experience the new UI. Be proactive in training and preparing them. In my experience with clients, organizations that have introduced users to the new UI, with as little as a 30-minute introduction, have found the transition to be significantly smoother than those that haven't prepared end users. Microsoft provides several Office 2007 resources(e.g., training and command-reference guides) at http://office.microsoft.com, which you can incorporate into your enduser training.

Once the adjustment is made, the experience of Office 2007 early adopters confirms that the new UI enables users to be significantly more productive. In addition, the new file formats and deployment processes are easier for IT administrators to manage. Most importantly, the power of Office 2007, which includes Windows SharePoint Services and support for technologies such as information rights management (IRM), means that collaboration, knowledge management, business intelligence, and security will add real business value. This isn't just Microsoft hype; I've seen it firsthand. And as Office 2007 rolls onto desktops, we'll all begin to gather real-world experience with the good, the bad, and the ugly in the newest overhauled Office version.

Has the number of rows and columns supported by Microsoft Office Excel 2007 changed?
The long-standing
limitation of 256 columns (A to ZZ) and 16,384 rows has been expanded to include worksheets up to 16,384 columns (A to ZZZ) and 1,048,576 rows.

Will my computer have enough horsepower to run Office 2007?
Most likely, yes, if you're using a computer purchased within the last year or two. However, Microsoft has changed how it states an application's hardware prerequisites, and Microsoft's numbers sometimes assume that you're running nothing but Office 2007. Check out Table 1 to see Microsoft's stated system requirements for Office 2007 versus what I think are probably more realistic requirement guidelines.

Excel 2007's conditional formatting has additional settings; what are they?
Figure 1 shows examples of the three new settings for Conditional Formatting: Color Scales, Icon Sets, and Data Bars. Color Scales color the background of a group of cells with different colors according to the values of the various cells. For example, in the Serial column in Figure 1, the color of the successive cells gradually changes from yellow to red as the cell values increase. Icon Sets precede the text in a cell with an icon that represents some aspect of the cell's value with respect to other values in a group of cells. In Figure 1, cells are marked as belonging to a specific group by a colored flag that precedes the integer in the Serial field. Data Bars show a gradient bar in a cell's background and can display information that might not be explicitly stated (i.e., with a numerical value) in the field.

I'm a little confused about differentiating themes, templates, and Quick Styles. Can you clarify what each of these features does, or at least point me in the right direction?
Your confusion is understandable, especially about themes, which are an entirely new feature, although older versions of Office had a (different) feature called "themes." An Office 2007 theme is a new, standalone file type (.thmx) that defines colors, fonts, and effects to create a distinctive, visually cohesive look for all Office 2007 documents. Default themes include Office, Urban, and Opulent. You can find them in the themes gallery in each application: on the Design tab in Microsoft Office PowerPoint 2007 and on the Page Layout tab in Microsoft Office Word 2007, Microsoft Office Outlook 2007 email messages, and Excel 2007.

   Previous  [1]  2  Next 


Reader Comments

You must log on before posting a comment.

If you don't have a username & password, please register now.




Top Viewed ArticlesView all articles
Friday at PASS Europe 2006

Kevin talks about the closing day of the event and shares a funny Microsoft film. ...

More fun TechEd 2005 Resources

Kevin points out some more TechEd resources ...

Microsoft Announces Upcoming Xbox 360 Milestones

Microsoft announced this morning that it will deliver a completely new user interface for the Xbox 360 on November 19, the New Xbox Experience, an update that will result in a "completely new Xbox 360." The company also revealed that it will be extending ...


News and Analysis Whitepapers MIMO Wireless LAN PHY Layer (RF) Operation & Measurement Application Note 1509

IT Industry Trends 2005 Study

The Who, What, Why, and Where of IT Events and Trade Shows

Related Events Check out our list of Free Email Newsletters!

News and Analysis eBooks Business Process Authentation - Managing Cost in Your Enterprise

Related News and Analysis Resources Become a VIP member of the Windows IT Pro community!
Get it all with the VIP CD and VIP access. A $500+ value for only $279!

Subscribe to Windows IT Pro!
Solve your toughest technical problems with our experts and access 10,000 + articles online. 30% off

Monthly Online Pass - Only $5.95!
Get instant access to 10,000+ articles from Windows IT Pro Magazine!

TechNet Virtual Labs
Evaluate and test Microsoft's newest products.

Job Openings in IT


ADS BY GOOGLE SPONSORED LINKS FEATURED LINKS

Microsoft Exchange & Windows Connections event returns to Las Vegas Nov 10 - 13
Connections returns to Las Vegas for this exciting event where each attendee will receive SQL Server 2008 standard with 1 CAL. Co-located with Microsoft ASP.NET, SQL Server, and SharePoint Connections with over 250 in-depth sessions.

Free Online Event! Virtualization:Get the Facts!
Register now and attend this free, live in-depth online conference on November 13 and 20, 2008, produced by Windows IT Pro. All registrants are eligible to receive a complimentary one-year digital subscription to Windows IT Pro (a $49.95 value)!

Check Out Hyper-V Video on ITTV
Watch Karen Forster's interview on Hyper-V's performance on ITTV.net.

Ease Your Scripting Pains with the Flexibility of PowerShell!
Join MVP Paul Robichaux on December 11, 2008 at 11:00 AM EDT as he equips you with PowerShell basics in 3 introductory lessons, each followed by a live Q&A session—all on your own computer!

Latest Advancements in SSL Technology
There are a variety of different kinds of SSL to explore to ensure customer data is kept confidential and secure. In this paper, we will discuss some of these SSL advances to help you decide which would be best for your organization.

PASS Community Summit 2008 in Seattle on Nov 18-21
The don’t-miss event for Microsoft SQL Server Professionals. Register now and you’ll enjoy top-notch Microsoft and Community speakers and more.



Solving PST Management Problems
In this white paper, read about the top PST issues and how to administer local/network PST Files.

Get Protected -- Data Protection Manager 2007
Protect your virtualized environment with Data Protection Manager

Order Your SQL Fundamentals CD Today!
Learn how to use SQL Server, understand Office integration techniques and dive into the essentials of SQL Express and Visual Basic with this free SQL Fundamentals CD.

Maximize Your SharePoint Investment: Get Your Data Moving
Watch this web seminar now to learn how to maximize your SharePoint investment! Join us as we take a look at the complex business of securing, accessing and managing vast amounts of information in a global network and various ways to get your data moving.
Windows IT Pro Home Register FAQ for Windows WinInfo News
Europe Edition About Us Contact Us/Customer Service Media Kit Affiliates / Licensing  
SQL Server Magazine Office & SharePoint Pro Windows Dev Pro IT Job Hound ITTV
IT Library Technology Resource Directory Connected Home Windows Excavator Windows SuperSite 
 
 Windows IT Pro is a Division of Penton Media Inc.
 Copyright © 2008 Penton Media, Inc., All rights reserved. Terms and Use | Privacy Statement | Reprints and Licensing