Web query containing worksheets still crashing after update 10.1.5

[Jacques Lacroute]

Hey,

I posted a message a while ago aboout all my worksheets with web queries
consistantly crashing since updating to 10.1.4. (and when I open an other
workshhet , they re-open and crash unless I desactivate the launch of
startup macros)
Apart from Bob Greenblatt's statement that he got the same problem and was
waiting for an answer I don't perceive this as gneneral issue.
Could someone confirm that he's got working web queries (updating at opening
time) in worksheets after all upgrades, this would make a complete
re-install an option for me.

Thanks

Jacques Lacroute

 

[Jim Gordon]

Hi Jaque,

Using 10.1.5 and Jaguar I went to the Data Menu and chose Get External Data

Run Saved Query. I chose the MSN Money Central Stock Quotes and was able to

get a quote without a problem.

I saved the workbook to the desktop, then closed Excel. Then I opened Excel
again and used the File Menu to open the saved workbook. It opened fine. It
also opened fine by dragging the workbook icon to the Excel icon in the
dock.

So there is nothing inherently wrong with web queries and version 10.1.5.

It is possible that Excel's preferences are messed up. If you don't mind
losing toolbar and other customizations you could (with Excel closed) trash
all of the Excel preferences, empty the trash, then open Excel and try
again. You have to empty the trash before opening Excel to keep Excel from
using the old preferences even if they are in the trash.

-Jim Gordon
Mac MVP

All responses should be made to this newsgroup within the same thread.
Thanks.

About Microsoft MVPs:
http://www.mvps.org/

Search for help with the free Google search Excel add-in:
<http://www.rondebruin.nl/Google.htm>

----------

 

[Jacques Lacroute]

Hi Jim,

Thanks for your help. It's funny but when I'm using the example web query,
it's working like you say. However my older queries (containing macros
written VBA, but working in the Mac) behave like I said.
One of the files is "recognized" as containing Excel 4 macros (years back
!!)
Whould it help if I post the Excel crash log (which I'm uncompetent to
decypher I'm afraid).
btw: putting away the prefs files did'nt improve the situation (although I
did a "fresh" install going through all the update's saga up to 10.1.5 again
- I forgot to cross check at a 10.1.2 stop over though)

Many thanks.

 

[Jim Gordon]

Hi

In order to make a worthwhile fresh install you must first remove office by
using the uninstall program on the Office CD.

Posting crash logs will not help at all, but posting the macro code and the
exact error messages you get (if any) will help.

-Jim Gordon
Mac MVP

All responses should be made to this newsgroup within the same thread.
Thanks.

About Microsoft MVPs:
http://www.mvps.org/

Search for help with the free Google search Excel add-in:
<http://www.rondebruin.nl/Google.htm>

----------

 

[Jacques Lacroute]

Hi Jim,

Actually I did run the uninstall program and then I reinstalled from the CD
and the different upgrades.

Waht puzzles me is that even simple request (my personal homepage) don't
work when the examples do ? Could it be that the text files I generate are
causing the problem ?

My file

WEB
1
http://perso.club-internet.fr/jlacr/index.html

Selection=EntirePage
Formatting=All
PreFormattedTextToColumns=True
ConsecutiveDelimitersAsOne=True
SingleBlockTextImport=False

And it does'nt work (access is public, therefore no protection)
If I try with my .mac homepage it doesn't work either


The error message I get is a very standard one:

Microsoft Excel has quit unexpectedly, other programs and applications are
left untouched (my translation from the french message).

I think I will have to think about a complete reinstall of OS X, etc.. Maybe
I should wait until Panther comes round.
Thanks


Le 10/09/03 5:07, dans (e-mail address removed), « Jim Gordon »

 

[Jim Gordon]

Hi Jaques

Your web query ran fine when I tried it. Are you using French language
install of OSX? Office? Perhaps there is a language issue in Excel. I will
ask a French MVP to investigate.

-Jim Gordon
Mac MVP

All responses should be made to this newsgroup within the same thread.
Thanks.

About Microsoft MVPs:
http://www.mvps.org/

Search for help with the free Google search Excel add-in:
<http://www.rondebruin.nl/Google.htm>

----------

 

[Corentin Cras-Méneur]

Hi Jaques

Your web query ran fine when I tried it. Are you using French language
install of OSX? Office? Perhaps there is a language issue in Excel. I will
ask a French MVP to investigate.

I wanted to try that but I have two problems:
I don't currently have Office X installed in French on my machine adn I
can't find the CD.
My user folder is on another partition and this consistantly makes the
visual basic environment crash which really doesn't make it easy to
check that :-\

On top of all that, I can't write VBA (well not much anyway).
The only thing I might add is that I've always had a very hard time with
the Fr or US version of Excel to get to web pages as I clicked on cells
formatted as hyperlinks. It might be related.

Maybe Bernard has a vbetter idea (and the possibility to test this). He
is far more knowledgeble in VBA and Queries in general than I am.


Corentin

 

[Jacques Lacroute]

I've investigated further and here's what I've found out:

I opened the MSN Money example with Hexedit and modified only the html text
with my homepage address (thus retaining CR/LF end of lines), saving it with
Hexedit: still crashing

Then I turned to my ibook where I had'nt updated Office for a while:
With SR1: the same file that crashes on my PowerMac works on the ibook.
Run the 10.2 update: still working
Runb the 10.4 update : crashes. (original MSN Money example works of
course..)

The issue now seems to stay with the 10.4 update, any clue ?

The crash seems to appear at the end of the loading data from the web phase.

I'm left with the option either to regress to 10.2 or to forget about web
queries.

Your help is very much appreciated

Jacques Lacroute

 

[Charles Whaley]

I can't contribute to the solution, but this web query thing is a VERY
real problem for me.

I installed 10.1.4 and 10.1.5 updates yesterday and ALL of my dozen or
so web query enabled streadsheets cause Excel to crash when it does a
data update.

I rely heavily on these workbooks to access realtime data for my
ongoing investment analyses. My day trading activities have come to a
complete stand-still because of this disastrous update.

I'll reinstall Excel if I have to, but that's not a solution in the
long run... just a short term workaround.

 

[Jim Gordon]

Hi

You didn't mention that you did one of the most important things that needs
to be done whenever you do something substantial to a program, such as
installing an update. If you have not run Disk Utility First Aid to repair
permissions, please do it and see if that fixes the problem.

-Jim Gordon
Mac MVP

All responses should be made to this newsgroup within the same thread.
Thanks.

About Microsoft MVPs:
http://www.mvps.org/

Search for help with the free Google search Excel add-in:
<http://www.rondebruin.nl/Google.htm>

 

[Jim Gordon]

Hi Charles,

You didn't mention that you did one of the most important things that needs
to be done whenever you do something substantial to a program, such as
installing an update. If you have not run Disk Utility First Aid to repair
permissions, please do it and see if that fixes the problem.


-Jim Gordon
Mac MVP

All responses should be made to this newsgroup within the same thread.
Thanks.

About Microsoft MVPs:
http://www.mvps.org/

Search for help with the free Google search Excel add-in:
<http://www.rondebruin.nl/Google.htm>

 

[Jacques Lacroute]

I didn't do it specifically for this update, but I'd run Norton Utilities 8
checks and repairs since on that disk.
I've just carried out a permission repair run of Disk First Aid utility and
no progress on my side I'm afraid.
(Don't really feel like a full system reinstall but fear it may be
necessary, if only I could be sure that the problem will then be fixed,
because it's a many hours job as I cannot use a straightforward back up that
would most likely restore the issue).

Jacques

Le 12/09/03 3:14, dans (e-mail address removed), « Jim Gordon »

 

[Charles Whaley]

Nice try, Jim, but no cigar !

You correctly assumed that I hadn't done the "repair permisions"
thing, because it was never an issue before OS X, and has never been
an issue for me as an early adopter of OS X and OS X applications.

It was interesting, though, to see all those "permission corrections"
flow by my screen with no impact on anything.

I was hoping that a real solution may have materialized by now, but I
suppose that I'll have to remove the 10.1.4/10.1.5 "degrade" by
reinstalling Office X from CD.

(I still gringe at having to do that, but day-trading is a significant
part of my livelihood and the latest MS "upgrade" has removed a
substantial part of my income.)

Charles P. Whaley, PhD
CEO, Information Technology Enterprises

 

[Charles Whaley]

For what it's worth...

I couldn't wait for a REAL solution, so I scrapped Office X and
re-installed it from CD. Since I know update 10.1.2 isn't a problem, I
re-installed that too.

Everything's back to normal now with my Web Queries workbooks.

If it wasn't virtually impossible to send MS a problem-report on this,
I would, so they can work on a fix. Last time I tried, there were no
Mac apps on the selection menu, so I couldn't submit the detailed
message I composed.

This, in spite of the fact that the reporting procedure clearly
recognized my Product ID number as MS Office X for Mac, before it told
me to go back and start over!

To quote Paul Saffo of the Instiute for the Future, "Microsoft is a
big intellectual roach motel. All the big minds go in, and they don't
ever come out."

Charles P. Whaley, PhD
CEO, Information Technology Enterprises.

 

[J.E. McGimpsey]

If it wasn't virtually impossible to send MS a problem-report on this,
I would, so they can work on a fix. Last time I tried, there were no
Mac apps on the selection menu, so I couldn't submit the detailed
message I composed.

From any Office v.X application, choose Help/Send Feedback on
Excel/Word/etc...

Takes you right to a mac-centric web page where you can paste in
your report.

You can also send an email to (e-mail address removed) (really). Make
sure that something like "Mac Excel" is in the subject line so that
it gets routed to the appropriate product manager.

 

[Jacques Lacroute]

Hi,

After a while, I decided to do a "fresh" reinstall of all my ibook.
Os 10.2.6 through combo update from 10.2 original CD
Then I anstalled:
Office up to 10.1.5 from original CD, through SR 1, 10.1.2, 10.1.3, 10.1.4

Plus a limited range of applications (On my PowerMac, some of shared
office's files were showing 4D or Bryce icons, so I did'nt reinstall these.
I ran a "forced" pre-binding on my PowerMac through Cocktail but no
improvement)

Corrected all permissions after install, and still the same problem:
The examples web queries work
The following query (excel saved as text)
WEB
1
http://www.yahoo.com

crashes as previously.

I did wrote to Microsoft two weeks ago, as you recommended, but no reaction.

Just to keep you informed

Jacques