Trouble Downloading into Excel

CellarTracker Main Site

Trouble Downloading into Excel

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> [Cellar Talk] >> CellarTracker Support >> Trouble Downloading into Excel

Page: [1]

Message

<< Older Topic Newer Topic >>

Trouble Downloading into Excel - 10/3/2007 3:06:06 PM

TomTom

Posts: 2
Joined: 10/3/2007
Status: offline

For some reason, I am not able to download into Excel. I type in the login name and password and nothing happens. I've double-checked the name and password and that doesn't seem to be the problem. I'm using a Mac OSX 10.4.10 and Excel 2004 for Mac.

Post #: 1

RE: Trouble Downloading into Excel - 10/12/2007 8:22:51 PM

AtlantaBill

Posts: 30
Joined: 7/1/2006
From: Atlanta, GA USA
Status: offline

I've been waiting for a response to your post because I am having the same problem. Does anyone have any suggestions as to what to do?

Bill

(in reply to TomTom)

Post #: 2

RE: Trouble Downloading into Excel - 10/12/2007 8:29:44 PM

Eric

Posts: 17326
Joined: 10/10/2003
From: Seattle, WA
Status: offline

Sorry about that.

On some computers it doesn't download automatically. But it's just a couple of clicks away:

On the LOGIN tab make sure you have entered your handle and password from the site. You will only have to do this once.
Switch to the WINE LIST tab.
Click into the first row.
If the EXTERNAL DATA toolbar doesn't pop up then RIGHT-CLICK (or CMD-CLICK on the Mac) on any toolbar and pick EXTERNAL DATA from the list of toolbars.
The second to last button is REFRESH ALL. Click on it.

Voila!

_____________________________

Cheers!
-Eric LeVine

http://twitter.com/cellartracker
http://facebook.com/cellartracker

(in reply to AtlantaBill)

Post #: 3

RE: Trouble Downloading into Excel - 10/16/2007 1:41:18 AM

Colonel Lawrence

Posts: 7118
Joined: 4/24/2006
From: Arabia
Status: offline

I had no problems and then - didn't work at all !

The key for me was that I had a new PC - with a higher level of security that blocked Eric's download.
Simply enabled the download and it's all back to normal.

90% of the time the problem is me, so I just plod around looking for what I did wrong.

Good luck with those downloads.
L

(in reply to Eric)

Post #: 4

RE: Trouble Downloading into Excel - 10/16/2007 9:23:21 AM

Eric

Posts: 17326
Joined: 10/10/2003
From: Seattle, WA
Status: offline

Yes, another thing to look for is overeager firewall software. Such software expects things like FireFox, Safari and Internet Explorer to access the Internet. However, few such programs expect the same from Microsoft Excel. Nice software will at least notice Excel trying to get to the web and ask if that is OK. Nasty software just denies Excel and leaves you scratching your head at why I say this should work...

_____________________________

Cheers!
-Eric LeVine

http://twitter.com/cellartracker
http://facebook.com/cellartracker

(in reply to Colonel Lawrence)

Post #: 5

RE: Trouble Downloading into Excel - 10/16/2007 9:24:43 AM

Eric

Posts: 17326
Joined: 10/10/2003
From: Seattle, WA
Status: offline

One other thing on the Mac. Excel 2004 could be the issue. They had problems with web queries in their older versions which are largely cleared up in OfficeX. That could also be what you are hitting.

_____________________________

Cheers!
-Eric LeVine

http://twitter.com/cellartracker
http://facebook.com/cellartracker

(in reply to Eric)

Post #: 6

RE: Trouble Downloading into Excel - 12/26/2007 10:11:23 AM

Greginnd

Posts: 2
Joined: 12/26/2007
Status: offline

Eric, thanks for the wonderful tool. FYI - Excel 2004 is the latest version for the mac. Office X was the 2001 version I think. Anyway, I did as you suggested and went to the wine list, clicked on an entry and the web toolbar appeared. I was able to refresh the data. I noticed that I had to do this for every single sheet. Is there a way to globally update all the sheets with one click?

(in reply to Eric)

Post #: 7

RE: Trouble Downloading into Excel - 12/26/2007 10:16:52 AM

Eric

Posts: 17326
Joined: 10/10/2003
From: Seattle, WA
Status: offline

On the toolbar that floats up, there should be a REFRESH ALL button on the right-hand side of the toolbar. That will do all of the sheets.

_____________________________

Cheers!
-Eric LeVine

http://twitter.com/cellartracker
http://facebook.com/cellartracker

(in reply to Greginnd)

Post #: 8

RE: Trouble Downloading into Excel - 12/26/2007 3:37:09 PM

Sticky

Posts: 7
Joined: 12/10/2007
Status: offline

Can't seem to get this to work either. I click refersh all and it says it the link can't be updated.

(in reply to Eric)

Post #: 9

RE: Trouble Downloading into Excel - 12/26/2007 5:06:52 PM

Eric

Posts: 17326
Joined: 10/10/2003
From: Seattle, WA
Status: offline

quote:

ORIGINAL: Sticky

Can't seem to get this to work either. I click refersh all and it says it the link can't be updated.

That means Excel is not allowed to see the web. Check your firewall.

_____________________________

Cheers!
-Eric LeVine

http://twitter.com/cellartracker
http://facebook.com/cellartracker

(in reply to Sticky)

Post #: 10

RE: Trouble Downloading into Excel - 1/7/2008 5:46:17 AM

JavaMonkey

Posts: 23
Joined: 11/14/2006
Status: offline

If the spreadsheet doesn't work for you, or you're using a different spreadsheet app, like OpenOffice, you can do this instead:

- Make sure you are logged into CellarTracker.
- Enter this URL into your browser: http://www.cellartracker.com/xlquery.asp
- You'll get a page with all of the data in a simple table.
- Save this page to your hard drive.
- You should be able to import that html file into your spreadsheet app.

I've done this with OpenOffice, and I imagine most spreadsheet apps should be able to import this.

(in reply to TomTom)

Post #: 11

RE: Trouble Downloading into Excel - 1/7/2008 10:36:16 AM

Eric

Posts: 17326
Joined: 10/10/2003
From: Seattle, WA
Status: offline

That page supports multiple download types too:

Wine Summary:
http://www.cellartracker.com/xlquery.asp?table=List&User=<your_login>&Password=<your_password>

Individual Bottle Listing:
http://www.cellartracker.com/xlquery.asp?table=Inventory&User=<your_login>&Password=<your_password>

Your Tasting Notes:
http://www.cellartracker.com/xlquery.asp?table=Notes&User=<your_login>&Password=<your_password>

Availability/Drinkability Report:
http://www.cellartracker.com/xlquery.asp?table=Availability&User=<your_login>&Password=<your_password>

Purchases:
http://www.cellartracker.com/xlquery.asp?table=Purchase&User=<your_login>&Password=<your_password>

Consumed:
http://www.cellartracker.com/xlquery.asp?table=Consumed&User=<your_login>&Password=<your_password>

Private Notes:
http://www.cellartracker.com/xlquery.asp?Table=PrivateNotes&User=<your_login>&Password=<your_password>

_____________________________

Cheers!
-Eric LeVine

http://twitter.com/cellartracker
http://facebook.com/cellartracker

(in reply to JavaMonkey)

Post #: 12

RE: Trouble Downloading into Excel - 1/19/2009 10:04:45 AM

Kathamo

Posts: 13
Joined: 7/24/2008
Status: offline

One suggestion if some of your tabs seem to be loading but not others - SCROLL UP. It seemed like some of my tabs weren't loading, but then I realized I was looking at row 450 (and my wine list is only about 50 bottles long).

(in reply to TomTom)

Post #: 13