I've just de-fragmented

[Barman]

Anybody fancy answering a particularly annoying Excel problem I have come up against? No? Thought not 

Oh, go on then... lets have a laugh    whilst we fix it...

Who's "we"?

I?ll have a bash at it? my brain is fresh. 

[The Moan Ranger]

One of my users has built a little Excel thingy that, when completed, sends itself via Outlook to an internal mailbox. That's fine.

At the point of sending, a warning message "This worksheet contains hidden rows or columns that the recipient casn unhide. Do you wish to continue?" Choose OK and off it goes and nothing unhides iteself.

If, however, you then forward the e-mail to someone else, all the hidden cells unhide themselves.

Any ideas?  We are running Office 2003.

[Barman]

One of my users has built a little Excel thingy that, when completed, sends itself via Outlook to an internal mailbox. That's fine.

At the point of sending, a warning message "This worksheet contains hidden rows or columns that the recipient casn unhide. Do you wish to continue?" Choose OK and off it goes and nothing unhides iteself.

If, however, you then forward the e-mail to someone else, all the hidden cells unhide themselves.

Any ideas?  We are running Office 2003.

It?s not that fresh? 

[Marley's Ghost (Imbiber of Spirits)]

One of my users has built a little Excel thingy that, when completed, sends itself via Outlook to an internal mailbox. That's fine.

At the point of sending, a warning message "This worksheet contains hidden rows or columns that the recipient casn unhide. Do you wish to continue?" Choose OK and off it goes and nothing unhides iteself.

If, however, you then forward the e-mail to someone else, all the hidden cells unhide themselves.

Any ideas?  We are running Office 2003.

That sort of thing is normal for MicroSnot software - suggest you check out their online help - there's probably a fix for it (along with other 1001 bugs).

[The Moan Ranger]

Blimey. If MG can't fix it, we will have to rely on V-P's own IT Yoda - the "Tel".  

[tel]

Blimey. If MG can't fix it, we will have to rely on V-P's own IT Yoda - the "Tel".  

Tel is swamped by a sea of paperwork.
The powers that be decided that today and the next 3 fridays should be "dressing down" days.
My comment this morning to explain my attire was that I thought they had said a "dressing gown" day

[The Moan Ranger]

Blimey. If MG can't fix it, we will have to rely on V-P's own IT Yoda - the "Tel".  

Tel is swamped by a sea of paperwork.
The powers that be decided that today and the next 3 fridays should be "dressing down" days.
My comment this morning to explain my attire was that I thought they had said a "dressing gown" day

Surely a uber cyber man like yourself doesn' use paper ?

[tel]

Paper is mainly invoices and my requisitions for expenditure to be approve at board meeting Monday.
My writing now resembles a childs after years of only using a keyboard.
Mind you my typing is not as good as it used to be.

[Misunderstood]

Us - the geniuses of the forum - of course.   or is it the geniuii?

[Grumpmeister]

Given the amount of bottles I suspect are being emptied here surely Geni would be more appropriate.

As for the excel problem, I suspect the only way around it is going to be to zip the file and manually email it.

[Misunderstood]

One of my users has built a little Excel thingy that, when completed, sends itself via Outlook to an internal mailbox. That's fine.

At the point of sending, a warning message "This worksheet contains hidden rows or columns that the recipient casn unhide. Do you wish to continue?" Choose OK and off it goes and nothing unhides iteself.

If, however, you then forward the e-mail to someone else, all the hidden cells unhide themselves.

Any ideas?  We are running Office 2003.

Um...    It seems to me that the 'problem' is not in Excel at all but in Outlook.   The original mailing would contain a flag that preserves the formatting that is set by the "Do you wish to continue?" dialogue.   That command is then 'lost' in the subsequent transfer and the default Excel behaviour of standardising the column widths re-establishes itself.

Anyway, it is obvious that the formatting is preserved in the first mailed option and the key objective is to maintain that state in further transfers.  Perhaps it would work as intended, if it were attached to a new mail rather than forwarded or - if the 'forward' is a routine matter - have it sent to that address in the first place with a c.c. - Or to a 'holding' file such as "Drafts" where it would wait to be manually dispatched on request, or deleted if unneeded.

[Darwins Selection]

One of my users has built a little Excel thingy that, when completed, sends itself via Outlook to an internal mailbox. That's fine.

At the point of sending, a warning message "This worksheet contains hidden rows or columns that the recipient casn unhide. Do you wish to continue?" Choose OK and off it goes and nothing unhides iteself.

If, however, you then forward the e-mail to someone else, all the hidden cells unhide themselves.

Any ideas?  We are running Office 2003.

Um...    It seems to me that the 'problem' is not in Excel at all but in Outlook.   The original mailing would contain a flag that preserves the formatting that is set by the "Do you wish to continue?" dialogue.   That command is then 'lost' in the subsequent transfer and the default Excel behaviour of standardising the column widths re-establishes itself.

Anyway, it is obvious that the formatting is preserved in the first mailed option and the key objective is to maintain that state in further transfers.  Perhaps it would work as intended, if it were attached to a new mail rather than forwarded or - if the 'forward' is a routine matter - have it sent to that address in the first place with a c.c. - Or to a 'holding' file such as "Drafts" where it would wait to be manually dispatched on request, or deleted if unneeded.

I knew that, but didn't want to be accused of 'mouse waving'.

[Sour Puss]

I knew that, but didn't want to be accused of 'mouse waving'.

Sometimes you just have to wave it 
http://www.everythingusb.com/logitech_mx_air_cordless_mouse_12952.html