What happens when a good Excel worksheet goes bad. Based on an article by Helen Bradley What happens when there’s an error in a worksheet? The answer is that it depends on what the worksheet is calculating and how bad the error is. Theoretically if an error were to over
We run through the basics related to date and time formats in Excel 2003. By Michael Barden Working with dates in Excel is a common task: Are you trying to determine the number of days between two dates? Do you need to know the date that is X number of
There’s no simple answer to which one is better, Google Apps online or Microsoft Office on your PC. by Peter Deegan, Editor-in-Chief, Office Watch Google Applications has taken another step towards being the equivalent to online version of Microsoft Office, including now adding a paid version aimed at heavy users
Our new ebook is about all the amazing formatting options in Microsoft Word. We’re delighted to tell you about our latest ‘Quickie’ ebook – Formatting Magic with Word. There’s a lot more to Word than just bold, italics, underline and other options that can be squeezed onto the toolbars. Formatting
Interesting comments and stories from our readers Some interesting messages from readers after our last issue regarding access to email accounts after the death of the user. In that article we deliberately kept our comments general – the legal situation for executors or estate administrators varies between countries and states.
Some thoughts about a ’12 step’ program for email junkies. Another article that caught my eye was on CNN Twelve-steps to curing e-mail addiction. Being overwhelmed by email is certainly a problem, but we’re not sure that some of the suggestions are the right course. In particular the idea of
What happens if you need to access webmail for someone who has died? And what should you do to prepare? An interesting article in the Sydney Morning Herald about access to email accounts after the account holder dies. This caught Peter’s eye because in a previous decade (pre-email) he worked
‘Clever Outlook Contacts’ and ‘Organising Outlook Email’ both updated for Outlook 2007. We’ve updated both of our popular Outlook ebooks to include Outlook 2007. Peter has added an entire new chapter to Clever Outlook Contacts with detail and tips specific to Outlook 2007. There’s now over 20 extra pages of
From: www.ExcelUserConference.com Atlantic City, New Jersey will once again host the Microsoft Excel / Access User Conference (Trump Marina Hotel) – On April 18-20, 2007. Atlantic City, New Jersey will once again host theMicrosoft Excel / Access User Conference (Trump Marina Hotel) – On April 18-20, 2007. This year the
Is your Outlook 2007 ‘instant’ search working properly? Is your Outlook 2007 ‘instant’ search working properly? We’ve had plenty of trouble finding messages that are clearly stored in Outlook 2007 but won’t show up in any search. We suspect the problem is either related to multiple Outlook profiles or an
Many readers have wondered about the effect of the ‘key generators’ that are available on pirate software sites. Some interesting responses to our series “If your product key is stolen” Part 1 and Part 2 . Many wondered about the effect of the ‘key generators’ that are available on pirate software sites.
The Outlook 2007 reading pane looks the same as the one in previous versions but it’s actually quite different and safer. The Outlook 2007 reading pane looks the same as the one in previous versions but it’s actually quite different and safer. There has always been a concern that a
Updates for the Junk Mail filter for Outlook 2003 and Outlook 2007 are now available. Updates for the Junk Mail filter for Outlook 2003 and Outlook 2007 are now available: Outlook 2003 update for more details here Outlook 2007 update details should be here but that KB article wasn’t available when we checked
We delve even further into the AutoFill options in Excel and find out how to create a custom fill list. By Michael Barden Last week, we had a look at the basics of AutoFill in Excel – a function that is used to “automatically fill in” a series of data
Microsoft Office security patches for February 2007 The usual collection of security patches for February 2007 – two of these concern Office and other is worth mention because it’s almost funny. Excel and Powerpoint vulnerabilities Office 2000 Office XP Office 2003 Excel Viewer 2003 Word Viewer 2003 Office 2004 for
Some tips when sending out many messages for a group or club. In a recent issue of Office Watch, Lee W asked about sending a large number of messages from an Access database: ” I have a need to send 50,000 emails w/ an attachment. The email addresses are currently
A summary of the options for converting documents between the Office 2007 formats and Office 97-2003 formats. We’re still getting a lot of messages about document compatibility between the new Office 2007 formats (.docx .xlsx etc) and the .doc .xls formats we’re all familiar with. If you have Office 2007
Sending many emails from Office is possible but there are traps. Lee W asks: ” I have a need to send 50,000 emails with an attachment. The email addresses are currently stored in a Microsoft Access database. Does Outlook have any limitations? “ You should not need any special code
What happened to the link to Contacts from Tasks or Appointments that used to be in Outlook? Laurence M writes: I am using Office 2007, and am very frustrated by the removal of the Contacts field. I used it a lot in v2003 in tasks and appointments, but it’s gone
We look at AutoFill – a powerful feature in Excel used to “automatically fill in” a series of data based on a small amount of input. By Michael Barden In this edition of Office for Mere Mortals, we will have a look at AutoFill – a powerful feature in Excel
With the full public launch of Windows Vista and Office 2007 happening, now is a good time for a reality check in order to balance the hype that you’ll be hit with. With the full public launch of Windows Vista and Office 2007 happening, now is a good time for
We answer some common questions about Office 2007 from Office Watch readers I don’t know whether it’s because of all the Microsoft promotional material about Office 2007 or in spite of it, but looking through the messages from Office Watch readers it’s clear that there are some misunderstandings about Office
We look at marking index entries across multiple pages, hidden text and a nifty add-on for regular indexers. By Michael Barden In the last issue of Office for Mere Mortals we looked at the basics of indexing in Word – setting up a document to be indexed and then generating
You hit Reply to answer a messages you received – simple right? Reply and Forward have hidden depths and tricks you should know. As often happens with Outlook and Office usual there is more that is worth knowing about, even in this simple email feature. There are options to “Reply”
