We help IT Professionals succeed at work.

Unable to open certain documents OWA Exchange 2007 SP1

Lilbuddha
Lilbuddha asked
on
I seem to be having some issue with Web Ready Viewing. I have the Exchange server set to allow all file types for Web Ready, which MS' site says will do xls. I can use an Excel document that just has some random stuff in cells for testing. I have sales managers that send info in a spreadsheet that doesn't open. It's an .xls document. I get a pop up box that says The document cannot be opened as a Web page. If the problem continues, contact technical support for your organization. This spreadsheet they're sending has their sales info in it. Could it be something in the spreadsheet that Web Ready can't display? The file is only 133KB. The only odd thing I noticed is a ~ in the file name. I saved it locally and renamed it. Sent again and still no luck. Web Ready Error on Excel .xls document
Comment
Watch Question

Maen Abu-TabanjehNetwork Administrator, Network Consultant
Top Expert 2011
Commented:
you need to configure webready document viewer for exchange 2007 ..see here :

http://technet.microsoft.com/en-us/library/bb852213(EXCHG.80).aspx
Maen Abu-TabanjehNetwork Administrator, Network Consultant
Top Expert 2011
Commented:
oops , i forgot also to show you how to configure it using OWA GUI

http://blogs.technet.com/b/exchange/archive/2007/03/23/3401668.aspx

Author

Commented:
I thought it was already configured since it will open Word and Excel documents already. It just won't open this one. I can open several test documents already.
Maen Abu-TabanjehNetwork Administrator, Network Consultant
Top Expert 2011
Commented:
try work around it , think about size and file format or even name of the file - the size appear 150K what about other documents or excel that opening using OWA is it less than 150k? second thing about the xls extension , and the third thing about the file itself is it contain any activeX like flash media? 3rd thing did you try to shorting the name of the file and send it again and see if its can be browsed?

Author

Commented:
I've tried to do the following:
1. I saved the original file locally, renamed it and sent it out via email. Wouldn't open.
2. I've created test files and they worked fine.
3. .xlsx doesn't appear to work, but .xls does even though MS tech says it should. (still researching that one)
4. Opened files larger that 150K and smaller than 150K. (Ours is set to 5MB file maximum).
5. No embedded flash or active x that I'm aware of.

I think it might have something to do with either the file format or formulas maybe?

Hopefully this helps.
Found the issue. The item they were trying to view had expandable columns on the sides which OWA wouldn't process. Had them copy the part they wanted to see and send that.

Author

Commented:
OWA wasn't displaying due to group and outline features. By having them use the mouse to copy the expanded report, they could copy that into a new Excel book and mail it. This worked perfectly.

Author

Commented:
All responses were right.