Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

General discussion

excel 2003 not keeping source formatting

Oct 6, 2007 11:44PM PDT

I'm trying to paste some data from a website into excel. The formatting used to look okay but now it does not, the formatted cells are no longer formatted the same as the source.

It works after i use detect and repair. But when I go to collect new data the keep source formatting doesn't work.

Any help would be appreciated.

Discussion is locked

- Collapse -
Why will have to wait until
Oct 10, 2007 3:59AM PDT

We can corral one or all of the programmers for Windows, your firewall and the office you are investigating. Sadly I think this will never happen. All I can offer is that such things do happen to Mcafee and Norton users. When they tire of this issue then we can move towards a solution. But "why?" is not likely to ever be told.

Bob

- Collapse -
Word hangs while pasting html from web page - same issue
Oct 10, 2007 10:57AM PDT

Yup this issue is all one in the same that I found here http://www.anetforums.com/posts.aspx?ThreadIndex=33168
which can also be traced to the same problem I am having.

As they said, unchecking the smart paste option doesn't work for me. Neither does paste special format RTF or unformatted option. It all pastes as normal font unformatted text, no coloring and lines for boxed in areas.

It should paste all the text like a print screen for word but it doesn't (ANYONE NO HOW TO DO THIS?), it formats it to plain text. As I said before it works fine when I'm offline.

Unblocking in the firewall takes forever to paste but it's okay, it should be able to paste fine when I block it, cause it works fine offline, so what gives?

- Collapse -
What gives is...
Oct 10, 2007 11:31AM PDT

Usually not ever revealed. However I have fixed this and numerous other glitches by moving away from the software that causes it.

If you insist on the cause you need to set aside some hours to call in to the support lines for your firewall product. So far no one has found out "why?"

Bob

- Collapse -
I'm pretty sure ...
Oct 10, 2007 5:00PM PDT

your firewall (or other Internet security software) is the cause of this issue, and also that the Windows XP firewall won't cause.

It seems you refuse to accept this idea, and are not even willing to test it by uninstalling that security software and see what happens. It's easy to prove and just as easy to disprove, but as long as you don't do that and keep looking for other causes (that you think more probable) we might never know.

And even if it's finally proved, you'll never know the WHY, just the THAT.

Kees

- Collapse -
I'm pretty sure
Oct 11, 2007 12:12AM PDT

If I uninstall Mcaffe I won't be able to re-install it, as it didn't come with mcafee software discs. Mcaffee was loaded on the computer when I got it. I never liked the way new computers get shipped with all sorts of software and then don't come with the install discs but Mcafee is great software and i don't want to loose it.

Might have to resort to doing a complete true backup of my whole hard drive then un-installing the software and trying it that way but that's a huge extreme.

I know the problem redides in copying the data to and from the clipboard when I'm online. Something is active.