Home > SharePoint 2007 > Setting the default Excel version for Export to Spreadsheet of Lists in MOSS 2007

Setting the default Excel version for Export to Spreadsheet of Lists in MOSS 2007


Since I’m using two versions of Office at the moment, 2003 and 2007 I sometimes get updates which overwrite several settings, resulting in certain actions being opened in Exel 2003 instead of Excel 2007. One of the annoying things was the Export to Spreadsheet of SharePoint lists opening with Excel 2003 instead of Excel 2007. Smart as I thought I was, it would be the xlsx files opening with Excel 2003 (with compatibility pack) instead of opening them with Excel 2007. And yes, they were set to default opening with 2003. Problem solved. I thought 🙂 The next export to spreadsheet resulted in opening in 2003 instead of 2007. What was the underlying problem. The iqy files (Excel Web Query Files according to my OS, although iqy stands for internet query) were set to default opening with 2003 as well. Changing that to Excel 2007 did solve my problem. Pretty straightforward to fix, but easy to miss. Hope this helps some people out there :p

Advertisements
Categories: SharePoint 2007
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: