Replies

Absolutely Stunning!

I didn’t think that it would be possible to do this within the Pivot table itself and I thought that it may need a solution that was slightly off the wall. It works perfectly – however one wee thing…ideally I would want the True/False column to be hidden and for the filter to automatically update as the pivot updates. Its not a biggie, but would just be the icing on the cake..

Thanks again – you’re an absolute star!

Alba

Hans – Thanks for getting bakc to me so quickly. I thought that might be the case, but just wanted to check.

I now have it working with Distribution Lists – its a bit more cumbersome, but workable, and will certainly save our Finance department many hours of work..

Thanks Again!

Alba

Hi there,

I’m glad to see that I am not alone with this problem!! I’m certain that we have seen a change with this behaviour recently as well and have looked through our documentation to see what we have been advising and I can see no mention of removing the numbering styles prior to copying and pasting..I’m absolutely certain that the numbering was removed as part of the paste unformatted text, and had really started to think I was losing it!

So I guess that this begs the question – if it is not longer working, and if this is by design, is there a way that this behaviour can be forced to happen? A setting that I am missing, a registry entry that makes all the difference?? Anything!!

Hi all,

Just in case any of you happen upon this problem yourself..it turns out that it is not just to do with the HP 3700 printer driver. I was unable to recreate the problem on other machines that had the same printer driver installed, but after going through a painstaking process of trial and error, have finally concluded that it is a combination of two factors:

1) Having the HP 3700 printer driver installed and

2) Having Adobe Acrobat 7.0 Standard installed.

I can now happily recreate the problem over and over again!!

Thanks very much Hans!! It turns out than once I uninstalled the printer and driver for an HP 3700 colour printer that the error stopped..I’m trying to recreate the problem with other machines and the same printer so that I can be 100% certain, but that seems to have done the trick!

Thanks again!

Alba.

HI there,

I am now truly stumped…

I have rebuilt the users profile. All was working for a few days and then the problem returned. I then completely rebuilt the machine. Again all was working well, and then a few days later the problem reoccured. Can anyone think of anything that a user could do that might cause behaviour like this??

Tried that thanks – but the detect and repair comes up with nothing. It happens with all Excel files not just specific ones. I have tried another profile on the machine and this allows me to copy with Excel and not crash when I open a new email – so I guess I need to go down this route..

Thanks for your help anyway!

Alba

I have configured the users machine to not use the DMS wihtin Excel but the problem still remained, and I have tested the same issue on a number of machines with the same DMS configured with the same files and have not been able to replicate the problem either. I’m guessing that building up a new profile for the user may be the next step..but she has 10s of Gigs worth of PST files stored in her My documents, and I’d rather find another solution that going down that route!

Thanks!

Worked like a charm Hans – tho I had to do it for her as she doesn’t have Access!!

Excellent idea Hans – I’ll give that a go!

Alba

Normally I would agree that the user should be using Word, however the mail merge that they are trying to achieve is so large that I cannot get it onto a Word document. Even when making the page size as large as possible – I can only see about half of the width of the table they are using as the source.

Another issue that is creeping in is that when performing the mail merge some of the contents of the cells fail to appear properly – the text is being cut off at between 260-265 characters – only on some cells, other cells are much longer and the entire text is appearing correctly within the merge.

I have tried copying the entire sheet to a new workbook, format painting the problem cells from the cells that merge correctly, changing the cell format between general and text, reducing the font size..can anyone else think of any reason why this would happen or suggest any way round it??

Thanks

We took a decision a number of years ago to ensure that Word as the email editor was switched off as there appeared to be so many problems with it. I guess, however that at the time we were using Office 97 – have things improved since then and is it advisable for all users? I suppose what I’m asking is will I see more problem other than a random paragraph increasing in size!?!

Thanks very much for your suggestions – I didn’t think that there was an easy answer to this one as I remember looking into it a while back and got nowhere! I’m sure that my suggestion to the user the last time was to use RTF format instead (they like the fancy colours and links in their signatures so plain text isn’t going to be much use!!).

Thanks again!!

Alba

P.S. I’ll get my email address updated..just need to find the profile section to do it in though!!

Hi hans,

You are an absolute gem – this works perfectly in every instance where I have tried. Thanks, thanks and thanks again!

Alba

Thanks for getting back to me on this issue. Unfortunately I have come across a few more instances of this issue and I wanted to get to the bottom of it all. I’ve had a hunt about the internet and have been surprised at how little info there is out there regarding track changes beyond the scope of how to turn them on and how to accept/reject changes! Can anyone point me in the direction of any info (guides, papers, expert opinions) discussing track changes specifically within complex outline numbered documents (sometimes with multiple styles)