Author Topic: I've just de-fragmented  (Read 16231 times)

0 Members and 5 Guests are viewing this topic.

Offline Barman

  • Administrator
  • Needs to get out more...
  • *****
  • Posts: 154194
  • Reputation: -50
  • Since 1960...
    • Virtual Pub!
Re: I've just de-fragmented
« Reply #75 on: July 13, 2007, 10:14:32 AM »


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

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

Who's "we"?
I?ll have a bash at it? my brain is fresh.  ;)
Pro Skub  Thumbs:

Offline The Moan Ranger

  • Administrator
  • Power Poster
  • *****
  • Posts: 13952
  • Reputation: 1
  • No surrender
Re: I've just de-fragmented
« Reply #76 on: July 13, 2007, 10:26:55 AM »
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.

Offline Barman

  • Administrator
  • Needs to get out more...
  • *****
  • Posts: 154194
  • Reputation: -50
  • Since 1960...
    • Virtual Pub!
Re: I've just de-fragmented
« Reply #77 on: July 13, 2007, 10:28:49 AM »
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?  surrender:
Pro Skub  Thumbs:

Offline Marley's Ghost (Imbiber of Spirits)

  • Fool Member
  • ***
  • Posts: 4917
  • Reputation: 0
  • What a dead end job . .
Re: I've just de-fragmented
« Reply #78 on: July 13, 2007, 12:13:36 PM »
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).
"Political Correctness is a doctrine fostered by a delusional, illogical minority, and rabidly promoted by an unscrupulous mainstream media, which holds forth the proposition that it is entirely possible to pick up a turd by the clean end." 

Well, someone had to say it!

Offline The Moan Ranger

  • Administrator
  • Power Poster
  • *****
  • Posts: 13952
  • Reputation: 1
  • No surrender
Re: I've just de-fragmented
« Reply #79 on: July 13, 2007, 01:48:51 PM »
Blimey. If MG can't fix it, we will have to rely on V-P's own IT Yoda - the "Tel".   worthy:

Offline tel

  • Senior Moment
  • ****
  • Posts: 6316
  • Reputation: 1
Re: I've just de-fragmented
« Reply #80 on: July 13, 2007, 02:20:04 PM »
Blimey. If MG can't fix it, we will have to rely on V-P's own IT Yoda - the "Tel".   worthy:
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 whistle:

     RTFM

Offline The Moan Ranger

  • Administrator
  • Power Poster
  • *****
  • Posts: 13952
  • Reputation: 1
  • No surrender
Re: I've just de-fragmented
« Reply #81 on: July 13, 2007, 02:40:30 PM »
Blimey. If MG can't fix it, we will have to rely on V-P's own IT Yoda - the "Tel".   worthy:
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 whistle:

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

Offline tel

  • Senior Moment
  • ****
  • Posts: 6316
  • Reputation: 1
Re: I've just de-fragmented
« Reply #82 on: July 13, 2007, 03:26:07 PM »
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.

     RTFM

Misunderstood

  • Guest
Re: I've just de-fragmented
« Reply #83 on: July 13, 2007, 07:56:20 PM »
Us - the geniuses of the forum - of course.   or is it the geniuii?

Offline Grumpmeister

  • Power Poster
  • *****
  • Posts: 36473
  • Reputation: -24
  • Prankmeister General
Re: I've just de-fragmented
« Reply #84 on: July 14, 2007, 10:15:49 AM »
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.
The universe is run by the complex interweaving of three elements. Energy, matter, and enlightened self-interest.

Misunderstood

  • Guest
Re: I've just de-fragmented
« Reply #85 on: July 16, 2007, 12:15:01 PM »
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...  rubschin:  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.

Offline Darwins Selection

  • Power Poster
  • *****
  • Posts: 39138
  • Reputation: 6
  • I mostly despair
Re: I've just de-fragmented
« Reply #86 on: July 16, 2007, 12:50:03 PM »
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...  rubschin:  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'. redface:
I mostly despair

Sour Puss

  • Guest
Re: I've just de-fragmented
« Reply #87 on: July 28, 2007, 03:15:49 PM »

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




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