Archive for the ‘Office’ Category
Posted by jpluimers on 2013/07/08
After having used the “classic” office since Office 95, there are still a few features that I can access blindly in Office 2003 and before, but have a hard time remembering in Office 2007 and beyond.
Most of those are the ones you rarely use, but the “classic office way” somehow made it in the autonomous nervous system.
It doesn’t help that the corresponding keyboard shortcuts fail to work in the “modern” Office versions any more either.
A few links on some PowerPoint features:
–jeroen
Posted in Office, Office 2007, Office 2010, Office 2013, Power Point, Power User | Leave a Comment »
Posted by jpluimers on 2013/05/30
If you install Office 2013 on Windows 8, be sure to transform the default Windows Update mechanism to Microsoft Update: that will get you the Office 2013 updates too.
Here are the one-time steps to accomplish that (which also work for other non-Windows products from Microsoft like Visual Studio, SQL Server, etc):
- Start the “Windows Update” window
- Click the link in “Get updates for other Microsoft Products. Find out more“
- Internet Explorer starts at the Microsoft Update page which detects you only have “Windows Update” configured and asks you if you want to configure “Microsoft Update” as well by agreeing to its Terms of Use.
- Clicking there refreshes the same page into “Choose how Windows can install Updates” page (I took the “current settings” choice)
- Click on the “Install” button
- In the UAC screen, confirm you are an Administrator
- Internet Explorer now refreshes the page to show “Find Windows Update using your Start Screen”
- “Windows Update” now will find updates for other Microsoft products like Office 2013 as well (some 300 megabytes in my case)
–jeroen
via: Office 2013 Plus on Windows 8 x64: how to force update? – Super User.
Posted in Office, Office 2013, Power User, Windows, Windows 8 | Leave a Comment »
Posted by jpluimers on 2013/04/16
So I won’t forget to research this:
excel “not enough storage is available to complete this operation (exception from hresult: 0x8007000e (e_outofmemory))” – Google Search.
Somehow this occurs with Excel and the .NET app only having a few dozen megabytes of memory in use, so the cause must be something a lot more simple than “out of memory”.
It is a complex export, but I might just be able to get this going using ADO.NET, and make sure it is not a 60+k rows or 60+k characters issue.
–jeroen
Posted in .NET, .NET 4.0, C#, C# 4.0, Development, Excel, Office, Power User, Software Development, Visual Studio 2010, WinForms | Leave a Comment »
Posted by jpluimers on 2013/03/04
Question: How do you make Excel print those cell lines?
Thanks seb32:
I’m assuming you want to print the grid…
- File menu,
- Page Setup,
- go to the Sheet tab,
- On that page, under Print, there’s a checkbox called “Gridlines”.
Note: the above is for Excel 2003; Print Gridlines in Excel shows that Excel 2007 and 2010 have slightly different settings.
–jeroen
via:
Posted in Excel, Office, Power User | Leave a Comment »
Posted by jpluimers on 2013/02/15
A while ago, I salvaged the Windows Mail *.eml files from a broken Vista machine of a friend to a new machine running Outlook. The Vista machine was so broken that it wouldn’t boot any more (now he knows that porn comes with truckloads of viruses).
Naively I assumed this was a straightforward process (hey, it’s all Microsoft, and they have great interoperability, right?).
Well no (:
- *.msg files are for Outlook, which does not support *.eml files
- *.eml files are for Outlook Express and Windows Mail, which supports exporting to Exchange (which is wrong, they mean “Export to the message store that Outlook uses)
So as soon as you have all mail in Windows Mail, then you can export it to Outlook.
You can do the same with *.dbx files from Outlook Express: use Windows Mail as an intermediate store as described here: Importing DBX files into Outlook 2007 – Windows Software.
But first things first.
Read the rest of this entry »
Posted in Office, Office 2003, Office 2007, Office 2010, Office 2013, Outlook, Power User | Leave a Comment »
Posted by jpluimers on 2013/01/28
A quick and easy way of getting the CurrentCulture and CurrentUICulture is to use the get-host cmdlet from PowerShell.
This is what PowerShell 2.0 shows on my system:
C:\Users\jeroenp>powershell get-host
Name : ConsoleHost
Version : 2.0
InstanceId : 1ce173fb-70a7-403b-a2bd-3800fe740f7c
UI : System.Management.Automation.Internal.Host.InternalHostUserInterface
CurrentCulture : en-IE
CurrentUICulture : en-US
PrivateData : Microsoft.PowerShell.ConsoleHost+ConsoleColorProxy
IsRunspacePushed : False
Runspace : System.Management.Automation.Runspaces.LocalRunspace
The SeaTools from Seagate can’t cope with that because they don’t manage the Resource Fallback Process properly.
My machine is on en-IE, as it is English, and USA as location.
The main advantage for me is to use the that it is a good mix between English and Dutch settings:
- English language (so you get proper error messages that you can find back using Google)
- USA as location (to force more search engines to use .com domains)
- EUR money settings (most software in Western Europe expects EUR, but displays USD when using en-US)
- decimal dot (far easier import/export with non-Dutch stuff)
- DD/MM/YYYY date format (I tried ISO 8601 YYYYMMDD, but that breaks too much software)
- 24 hour clock format (just as it should be)
- comma list separator (too much software is not configurable to use a certain separator for CSV, especially Excel depends on the system settings for list separator and decimal)
- metric system (just as it should be)
–jeroen
via: Get-Host.
Posted in .NET, CSV, Development, Excel, ISO 8601, Office, Power User, PowerShell, Scripting, Software Development | Leave a Comment »
Posted by jpluimers on 2013/01/17
Last year, I missed this tiny sentence:
So in plain English, any VM that was generated on VMware ESX Server 3.5 or later can run atop ESXi 5.1 unchanged.
Which means it is a snap to move your VMs from older ESX / ESXi / vSphere versions as long as they are ESX 3.x or later.
In fact hardware version 7 has the widest compatibility amongst ESX/ESXi/vSphere/Fusion/Workstation/Player versions (see the table at the bottom).
The free version still has a 32 gigabyte physical RAM limit (people are still confused by the vRAM / Physical RAM distinction, especially since vRAM is not limited any more). Read the rest of this entry »
Posted in ESXi4, ESXi5, ESXi5.1, Excel, Fusion, Power User, VMware, VMware ESXi, VMware Workstation, Word | Tagged: computer, hardware version, hardware versions, machine hardware, physical ram, software, technology, version compatibility, virtual hardware, virtual machine, virtual machines, vm, vms | Leave a Comment »
Posted by jpluimers on 2013/01/17
Every once in a while, Office Communicator indicates a contact is not off-line and allows me to send messages to him/her, but then gives an error 504.
The reason is that the off-line status replicates slowly, so you were not aware your contact went off-line while typing the message.
The Error ID 504 is just an unfrienly way of saying “your contact went off-line, but you didn’t know that when sending the message, and I don’t have a friendly way of telling you this”.
–jeroen
via: Communicator 2007 R2 Help on Error ID 504.
Posted in Communicator, Office, Power User, Windows, Windows 7, Windows XP | Leave a Comment »
Posted by jpluimers on 2012/12/28
One thing I always forget (especially since the UI in Office 2007 changed quite a bit, but the idea below gets me going).
I’m assuming you want to print the grid…
- File > Page Setup,
- then go to the Sheet tab.
- On that page, under Print, there’s a checkbox called “Gridlines”.
–jeroen
via How do you make Excel print those cell lines? – AfterDawn: Forums.
Posted in Excel, Office, Power User | Leave a Comment »
Posted by jpluimers on 2012/11/30
In Excel I always got confused with named ranges, as I thought they were hard to track.
Not!
The F3 keyboard shortcut gives you a list of named ranges including name and location. Which makes it way easier to work with named ranges.
See the excellent post Show all named ranges in Excel: It even has an animated gif image that shows you F3 in action.
–jeroen
via: Show all named ranges in Excel – Spreadsheet Audit & Maintenance Tip | Chandoo.org – Learn Microsoft Excel Online.
Posted in Excel, Keyboards and Keyboard Shortcuts, Office, Power User | Leave a Comment »
The Wiert Corner - irregular stream of stuff 