Posts Tagged ‘microsoft office 2007’

h1

Finding the size of a Microsoft Office 2007 file

10/01/2010

Prior to Microsoft Office 2007 (MSO2007), office provided a quick and simple way to find out just how big your file was.  This was done by selecting the properties option from the file menu which then displayed the same file properties dialog box that you could select from the file in Windows Explorer.

In MSO2007 the information is still available, but has been annoyingly ‘hidden’ somewhat deeper in the application.  In fact it is so awkwardly hidden that I know many people have not come across how to access it … so I thought I’d share.

Along with the menu item click options I’ve included the accelerator / shortcut keys to help make this as quick as possible.

  1. Select the ‘Office button’ [ALT+F].
  2. Select the ‘Prepare’ menu item [Press E].
  3. Select the ‘Properties’ menu item [Press P].
  4. In the ‘Document Properties’ section that appears, click the title (“Document Properties”) of the section to reveal a drop down list containing just one item – ‘Advanced Properties’.  Select this item to display the file properties.

NB: Please keep in mind that until you save a file, the properties window will not provide a file size though other file properties may be populated.

Advertisements
h1

Multiple Monitors

08/12/2009

Several months ago I got a Dell Latitude E6400 laptop to replace my overworked Dell Latitude D410.  Along with the laptop I got a new advanced E-dock which included two monitor outputs, so I recycled an old smaller monitor that had been relegated to the stores to have a dual monitor set-up.

I find the two monitor set-up really useful and I frequently have different applications in different windows as you might expect.  However I struggled with Excel as I would frequently want to copy data between large format spreadsheets and I would have loved to have one on each screen … but they simply opened as child windows and I Alt-Tab’d between them.

I guess I never really stopped to think about it, but one day my subconscious kicked in and I realised that if I chose not to open the files directly I could open multiple instances and then open a file in each.  Then each instance of the application can be dragged to a different monitor.  Hey presto a spreadsheet in each window.

h1

Overlaid Text Display Problem

07/04/2009

I came across a bizarre issue today in Microsoft Word. A user had a document containing a set of information laid out in a tabular format where the text in each cell was being condensed and overlaid so that the text was all being placed one character on top of another. The image shown here illustrates how “Hello world” looks when the characters are overlaid one on top of another.

compressed-font

Plain text and all the letters on top of one another

Copying and pasting the text out of a cell into the main body did not resolve the overlay issue.  Pasting the text into notepad did however prove that the text was indeed intact.  Therefore the issue was something that related to lay out.

There were no style or formatting settings that seemed to affect the character spacing in the way I expected so I then tried changing the font.  Originally it was set to Times New Roman, but changing it to another font restored the text to a legible format.  Changing it back to Times New Roman again incurred the overlay issue.  This suggested a font corruption.

I also tried adjusting the size of the text.  It then turned out that any size other than 12 pt resulted in the text being disaplyed correctly.  So anything but Times New Roman 12 pt was displayed correctly.

I had a quick look at the font file (found in the fonts applet in control panel in Windows XP) and the 12 pt size loked okay which suggested that it was something else affecting the way in which Word was laying it out on the page.  The page layout view was being used and this is built from the parameters of the current printer driver.

I changed the printer from the network HP printer located a few desks away to a CutePDF printer … and lo and behold the text appeared as normal.  I set it back to the HP printer and the overlay issue returned.  It seems a corruption in the printer driver was causing the issue.

I deleted the HP printer and then reinstalled it.  The text in the document was once again visible in Times New Roman 12 pt and the user also succeeded in printing out the document (which had previously suffered from the same issue as that seenon screen).

So if you have a bizarre layout issue in Microsoft Word that changing style based settings doesn’t seem to clear, try changing or reinstalling your printer.

h1

Can’t XPerience a canvas

01/03/2009

Microsoft Office Labs have launched an exciting new addition to One Note – Canvas for One Note.  This is the same idea as pptPlex for PowerPoint and instead off slides it amalgamates One Note notebook pages into a single canvas.  You can then zoom in and out and edit pages on a desktop like layout.

I was keen to give it a try, but unfortunately it currently only installs on Vista or a newer Windows operating system.  pptPlex will run on Windows XP so this was a bit of a surprise to me when I tried installing it (though in fairness the download page does list Vista as a pre-requisite).  Surely if pptPlex can run on XP OneNote can too….

According to a discussion thread on the Office Labs site there’s an idea that this limitation is actually down to the installer rather than the software so here’s to hoping that Office Labs do themselves a favour and widen their test base by offering an XP compatible installer.

h1

PowerPoint – Mastering the canvas

12/01/2009

Every presentation these days involves Microsoft PowerPoint.  After a while no matter how much multimedia you add to it, your presentation can still look a bit dull and boring.  In order to make your next presentation a bit different why not try pptPlex – a PowerPoint plugin that rebuilds a set of slides into a single ‘zoomable canvas’.

I saw this used by James Senior of Microsoft at the Misco Expo in October 2008 on a presentation about SBS, EBS and MS Server 2008.  It worked really well and added a new dimension to the way in which the presentation was delivered.  It also allowed him to skip around and to show areas that were collections of slide that fit together like a jigsaw but could then be zoomed in.