Results 1 to 11 of 11
  1. #1
    5 Star Lounger
    Join Date
    Dec 2009
    Location
    Pittsford,NY
    Posts
    874
    Thanks
    517
    Thanked 35 Times in 27 Posts

    need help with query table problem

    I have Microsoft office 2007 on my Windows 7 desktop.
    I have downlaoded an xls file that I want to use (a portfolio tracker that is supposed
    to update various fields.)
    When I open it, I get the following message:

    This workbook was last saved by an earlier version of Excel. The following data may have been lost:
    .Query Table

    I'm an Excel novice, and was wondering where to find the table in the workbook to update it; and/or how to resolve this problem.

    I would appreciate any help offered.

    Thanks,
    Dick

  2. #2
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts
    This is a new error message for me. Are there links in the file?
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  3. #3
    5 Star Lounger
    Join Date
    Dec 2009
    Location
    Pittsford,NY
    Posts
    874
    Thanks
    517
    Thanked 35 Times in 27 Posts
    A fellow Canadian, who goes by the handle of "Gummy", posted years ago an Excel workbook called Portfolio-tracker.xls

    It's supposed to automatically update prices for symbols you put in, and for other portfolio totals, by linking to the Yahoo site.

    When I try to use it I get the above error message. When I look on the Data ribbon and click on "connections", nothing shows.

    Dick

  4. #4
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts
    When I try to download it - I get a message that the file is corrupted...
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  5. #5
    5 Star Lounger
    Join Date
    Dec 2009
    Location
    East Coast, USA
    Posts
    993
    Thanks
    8
    Thanked 43 Times in 43 Posts
    Quote Originally Posted by WebGenii View Post
    When I try to download it - I get a message that the file is corrupted...
    I just downloaded the file and it opened in Excel 2010. When I click on enable editing I get the attached message......


    I have an Excel Add-In that does stock tracking using MSN StockQuote. It works in Excel 2003, I'll give it a try in Excel 2010.
    Attached Images Attached Images

  6. #6
    5 Star Lounger
    Join Date
    Dec 2009
    Location
    East Coast, USA
    Posts
    993
    Thanks
    8
    Thanked 43 Times in 43 Posts
    This site lists some alternatives for getting stock quotes.
    MSN MoneyCentral Stock Quotes Add-In for Excel is a free Microsoft Excel add-in

    See the Post by Jack on May 18, 2010 at 9:28 pm, and the posts that follow Jack's. The file published by Microsoft (msnsq.exe) is the one I have used in Excel 2003 for a few years. Today, I loaded that into Excel 2010 and it seems to be working fine. Please note - Microsoft no longer supports it.

    HTH

  7. #7
    5 Star Lounger
    Join Date
    Dec 2009
    Location
    Pittsford,NY
    Posts
    874
    Thanks
    517
    Thanked 35 Times in 27 Posts
    tfspry:
    Did you use it on Portfolio-tracker successfully?
    Dick

  8. #8
    5 Star Lounger
    Join Date
    Dec 2009
    Location
    East Coast, USA
    Posts
    993
    Thanks
    8
    Thanked 43 Times in 43 Posts
    Quote Originally Posted by Dick-Y View Post
    tfspry:
    Did you use it on Portfolio-tracker successfully?
    Dick
    Hi Dick - Sorry !
    I tried "Portfolio-tracker" using Excel 2003 and Excel 2010 and get the error message shown in Post #5. I could see the info/instructions on the "Portfolio-tracker" sheets.

    Since, I have had success with the free MSN Excel Add-In, I did not do any investigating of the "Portfolio-tracker" error. The MSN Add-In gives more info on individual stocks.

  9. #9
    5 Star Lounger
    Join Date
    Dec 2009
    Location
    East Coast, USA
    Posts
    993
    Thanks
    8
    Thanked 43 Times in 43 Posts
    Here is a sample of data available thru MSN Add-in.....
    Attached Files Attached Files

  10. #10
    5 Star Lounger
    Join Date
    Dec 2009
    Location
    Pittsford,NY
    Posts
    874
    Thanks
    517
    Thanked 35 Times in 27 Posts
    tfspry:
    Thanks for pointing me in that direction. I was hoping to use the already-existing Portfolio-tracker.xls

    If no one can can suggest how to get that working with Excel 2007, I guess I'll have to reinvent the portfolio wheel.

    Dick

  11. #11
    5 Star Lounger
    Join Date
    Dec 2009
    Location
    East Coast, USA
    Posts
    993
    Thanks
    8
    Thanked 43 Times in 43 Posts
    Quote Originally Posted by Dick-Y View Post
    A fellow Canadian, who goes by the handle of "Gummy", posted years ago an Excel workbook called Portfolio-tracker.xls

    It's supposed to automatically update prices for symbols you put in, and for other portfolio totals, by linking to the Yahoo site.

    When I try to use it I get the above error message. When I look on the Data ribbon and click on "connections", nothing shows.

    Dick
    Hi Dick - "Gummy" seems to have retired, but he left a boatload of Excel files ...
    Index of /Excel
    Maybe some of those will help.

    Here are a couple of sites that include "Gummy"

    Gummy gone !

    http://www.financialwebring.org/gummy-stuff/

    Where Investors Meet for Financial Education and Empowerment

    HTH

  12. The Following User Says Thank You to tfspry For This Useful Post:

    Dick-Y (2011-05-07)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •