Home > MBS - EDL and PL, News & Feedback > Datastream and Office 2007

Datastream and Office 2007

The database PCs in the Eddie Davies Library (all except one) are now updated to Office 2007.

This means that the Datastream and Thomson One Banker Excel Add-ins look slightly different. However it also means that you don’t need to worry about the 256 column limit when downloading large amounts of data.

Thomson One Banker in Office 2007
Thomson One Banker Excel add-in in Office 2007.
Note that to login you select the padlock icon at the top left.

Due to the MBS user setup, you may get a warning message about a “missing file” (ANALYS32.XLL)  when using Thomson One Banker. This can be ignored. The TOB Excel add-in should work fine.

One database PC is still on the old setup as a temporary measure for access to Company Analysis and Compustat (not-via WRDS).

Advertisements
  1. markgreenwood
    3 June 2010 at 5:21 pm

    Further investigation has shown that there is still a 256 column limit using the Datastream AF0 Excel add-in.

    The database PCs in the Eddie Davies Library have both Excel 2007 and Excel 2003. Datastream AFO detects the presence of Excel 2003 and limits any request to 256 columns.

  2. markgreenwood
    24 January 2011 at 12:24 pm

    [IGNORE – see comment 19 April 2012]
    New database PCs in Eddie Davies Library training room only have Excel 2007. (Thanks to MBS IT services for installing these last week.)

    If the (Excel 2003) 256 column limit is causing you a problem when using Datastream AFO, then use PC2 or PC3 in the Eddie Davies Library Finance Zone. (Unsure email libdesk at mbs.ac.uk )

  3. markgreenwood
    19 April 2012 at 10:48 am

    Database PCs in the Eddie Davies Library training room have both Excel 2007 and Excel 2003. This means that the 256 column limit when using the Datastream AFO Excel add-in still applies.

  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