BlackBerry Forums Support Community

Closed Thread
LinkBack Thread Tools
Old 03-14-2006, 11:05 AM   #1 (permalink)
Talking BlackBerry Encyclopedia
Join Date: Sep 2005
Location: Illinois
Model: 9850
PIN: k Floyd \m/ ROCK!
Carrier: VZW
Posts: 249
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default Odd Excel Spreadsheet issues when opening on BBs

Please Login to Remove!

Running BES 4.0 latest SP with hotfixes applied, I have an excel spreadsheet that when being emailed to users they cannot open, it just shows the clock and hangs.

Thinking it was a size issue, I went into the spreadsheet, theres quite a few sheets in there itself, 27 sheets to be exact, the first 25 are no more then 44 rows down by 25 columns across (A - Y), the last two are "help" sheets that are roughly 100some rows down by one column (A).

In its entireity the file size is 330k or so, no limit is set in the attachment service on the BES so thats not it.

Now heres the kicker, thinking it was a size issue, I started removing some sheets, I removed the very last two sheets, the help sheets that are about 100 x 1 and re-sent myself the file, it opens fine.

Any ideas?

I'm no genius when it comes to excel so I've no idea if theres something going on like code behind the pages or something?

Why would the last two sheets cause the issue?

Users have "claimed" that this file opened last year and stopped around November, the guys who put the file together say nothign has changed in the file at all, in fact I was able to find an old copy from '05 back in June, July, November, Sept, etc and they still won't open.

After I remove the last two help sheets, they open fine.

When running through the Attachment service test, it fails on the full file, but with the two help sheets removed it converts fine and gives me output.
"I dont feel I need to explain my art to you Warren"
Old 03-14-2006, 11:31 AM   #2 (permalink)
Thumbs Must Hurt
Kablooey's Avatar
Join Date: Aug 2005
Location: Southern Maryland
Model: 9800
PIN: 25ee2d53
Carrier: AT&T and Verizon 9650
Posts: 132
Post Thanks: 0
Thanked 0 Times in 0 Posts

There is either corrupt data that the attachment distiller can't read or there is some sort of formula or macros that the distiller can't process.
I Bet God Has A BlackBerry!
Closed Thread

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

1PC new TP.RD8501.563 LED universal universal motherboard
1PC new TP.RD8501.563 LED universal universal motherboard picture1PC ADLINK Industrial Motherboard NUPRO-841 REV:3.0
1PC ADLINK Industrial Motherboard NUPRO-841 REV:3.0  picture1PC new CV338H-A50 motherboard PC821
1PC new CV338H-A50 motherboard PC821 picture1PC new TP.RT2984D.PB831 motherboard
1PC new TP.RT2984D.PB831 motherboard picture1PC used CV59SH-A32 TV motherboard
1PC used CV59SH-A32 TV motherboard picture

Copyright 2004-2016
The names RIM and BlackBerry are registered Trademarks of BlackBerry Inc.