I am having a very perplexing problem opening an XLSX spreadsheet...
Actually I can open it fine, it's a couple of users that are having
the problem.
We have a couple of files parked on our intranet server done in Excel 2010.
When these users click on the web link instead of opening with Excel
like they normally would, they are prompted with a "Do you want to
open or save this file?" dialog, it shows the file name as being XLSX,
but the little icon is appearing as a compressed folder icon rather
than the green X thingy.
I tried the obvious stuff first by confirming file associations for
both Excel and Zip - they were fine, but I re-associated them anyway.
Compatibility Pack - googling suggested it might be the compatibility
pack for Office so I uninstalled that. No change.
I told IE7 to Open file based on extension rather than content - no joy.
I read that the XLSX format is indeed a compressed file format, but no
one else (that I know of - yet) is having any problems with these two
files. We've been using them for years...
Navigating to the folder where the files live, double clicking, opens
them just fine. Going into Excel, navigating to the files, opens them
just fine.
And of course it's a major hassle to get access to one of these
computers to mess around with trying to find a solution for them -
argh...
Any other suggestions for things to try?
--
Matt Jarvis
Eugene, Oregon USA
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/CAPT54rbUvASKmPHJ+oTnW=6Kg3oZjyJYvXvC47womfXK1Hjo=Q@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Just wondering....the folks that have this problem, are they using the
same OS? Same OS level?
Mike
-------- Original Message --------
Subject: [NF] perplexing Zip/Excel problem
From: M Jarvis <brewdaddy@gmail.com>
To: profoxtech@leafe.com
Date: 2/4/2013 1:16 PM
> I am having a very perplexing problem opening an XLSX spreadsheet...
> Actually I can open it fine, it's a couple of users that are having
> the problem.
>
> We have a couple of files parked on our intranet server done in Excel 2010.
>
> When these users click on the web link instead of opening with Excel
> like they normally would, they are prompted with a "Do you want to
> open or save this file?" dialog, it shows the file name as being XLSX,
> but the little icon is appearing as a compressed folder icon rather
> than the green X thingy.
>
> I tried the obvious stuff first by confirming file associations for
> both Excel and Zip - they were fine, but I re-associated them anyway.
>
> Compatibility Pack - googling suggested it might be the compatibility
> pack for Office so I uninstalled that. No change.
>
> I told IE7 to Open file based on extension rather than content - no joy.
>
> I read that the XLSX format is indeed a compressed file format, but no
> one else (that I know of - yet) is having any problems with these two
> files. We've been using them for years...
>
> Navigating to the folder where the files live, double clicking, opens
> them just fine. Going into Excel, navigating to the files, opens them
> just fine.
>
> And of course it's a major hassle to get access to one of these
> computers to mess around with trying to find a solution for them -
> argh...
>
> Any other suggestions for things to try?
>
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/51100A15.3040108@ggisoft.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
On Mon, Feb 4, 2013 at 11:20 AM, Mike Copeland <mike@ggisoft.com> wrote:
> Just wondering....the folks that have this problem, are they using the same
> OS? Same OS level?
>
> Mike
>
Sorry - forgot to mention XP SP 3... one user is next to me here in
the IT dept and she's 100% patched and such and has the problem.
--
Matt Jarvis
Eugene, Oregon USA
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/CAPT54rbiwnrJ085nFVk_p=G_TjA9rreOTvbmtGxjNg83pyO42w@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
M Jarvis wrote on 2013-02-04:
> On Mon, Feb 4, 2013 at 11:20 AM, Mike Copeland <mike@ggisoft.com> wrote:
> Just wondering....the folks that have this problem, are they using the
same
> OS? Same OS level?
>
> Mike
>
>
> Sorry - forgot to mention XP SP 3... one user is next to me here in
> the IT dept and she's 100% patched and such and has the problem.
Jarvis,
Which browsers fail? All installed on the machine?
Tracy Pearson
PowerChurch Software
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/002e01ce030e$4caf1090$e60d31b0$@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
>
> Which browsers fail? All installed on the machine?
>
Each of the two failing machines only has IE7 installed.
--
Matt Jarvis
Eugene, Oregon USA
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/CAPT54rZEco9z4mPKhujQdBsZ_vVg56qf3Dnd71WH7BLMk8QHgA@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
*Is your internet server an Apache server?*
*
*
*Linux using 'magic' to look at the files contents and determines that an
XLSX file is, in fact, a ZIP file. (It is!)*
*
*
*Internet Explorer gets the MIME content from the Apache server telling it
that an XLSX file is a ZIP file and, in its wisdom, adds .zip to the end of
the file. And Windows hides the file extension, just to wrap the whole
problem up in a neat little bow.*
*
*
*Oh, and when you try to look at it in Explorer, it helpfully opens the
file as if it were a folder, so you see a manifest file and other such ugly
internals of an XLSX file that should never see the light of day.*
*
*
*The solution is to add a couple of MIME types to the Apache config.*
*
*
*If this is your situation, and you have trouble Googling it, drop me a
line and I'll look up the settings I made recently on a client machine.*
*
*
On Mon, Feb 4, 2013 at 2:16 PM, M Jarvis <brewdaddy@gmail.com> wrote:
> I am having a very perplexing problem opening an XLSX spreadsheet...
> Actually I can open it fine, it's a couple of users that are having
> the problem.
>
> We have a couple of files parked on our intranet server done in Excel 2010.
>
> When these users click on the web link instead of opening with Excel
> like they normally would, they are prompted with a "Do you want to
> open or save this file?" dialog, it shows the file name as being XLSX,
> but the little icon is appearing as a compressed folder icon rather
> than the green X thingy.
>
> I tried the obvious stuff first by confirming file associations for
> both Excel and Zip - they were fine, but I re-associated them anyway.
>
> Compatibility Pack - googling suggested it might be the compatibility
> pack for Office so I uninstalled that. No change.
>
> I told IE7 to Open file based on extension rather than content - no joy.
>
> I read that the XLSX format is indeed a compressed file format, but no
> one else (that I know of - yet) is having any problems with these two
> files. We've been using them for years...
>
> Navigating to the folder where the files live, double clicking, opens
> them just fine. Going into Excel, navigating to the files, opens them
> just fine.
>
> And of course it's a major hassle to get access to one of these
> computers to mess around with trying to find a solution for them -
> argh...
>
> Any other suggestions for things to try?
>
> --
> Matt Jarvis
> Eugene, Oregon USA
>
[excessive quoting removed by server]
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/CACW6n4uTEnwVsY7gwmBhk=LXSha2x2xkpUzL+ROdb28rPbAy-w@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
On Mon, Feb 4, 2013 at 11:34 AM, Ted Roche <tedroche@gmail.com> wrote:
> *Is your internet server an Apache server?*
> *
<snipped>
Nope... and none of the other stuff mentioned seem to apply...
Like I said this has been working for years and years....
--
Matt Jarvis
Eugene, Oregon USA
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/CAPT54rZSD8+WU6qqwezRDSAUr0hzoXNyP5UMr6mbfUM3RYGX=g@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
On 02/04/13 11:16 AM, M Jarvis wrote:
> I am having a very perplexing problem opening an XLSX spreadsheet...
> Actually I can open it fine, it's a couple of users that are having
> the problem.
I believe the problem is that IE7 can't handle an .xlsx file. The .xlsx
is only from Excel 2010, and is really a zip file containing about 10
zipped up XML files - you can't open it in Excel 2007 either, because
nothing before 2010 knows about it.
IE 9 handles it fine, but you can't use IE 9 on XP.
Solution: Have the Excel 2010 user save it as .xls, and everybody will
be happy.
Dan Covill
San Diego
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/511016DC.2050103@san.rr.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.