?
Solved

Odd formatting imposed when copying worksheet to a new workbook

Posted on 2014-03-21
7
Medium Priority
?
226 Views
Last Modified: 2014-04-21
Under Excel 2010 whenever I copy an existing sheet to a new workbook, excel formats the text as bright green and borders as red. This never happened under prior Excel versions.  All my sheet have black borders, a dark fill in the headers and black text. I know how to fix it. Truthfully, my question is how to prevent this from happening. I would prefer Excel to retain the source format. I have a dozen macros and a dozen conditional formatting rules on the spreadsheet.
Odd-Exel-Formatting.jpg
0
Comment
Question by:RNikolai001
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
7 Comments
 
LVL 97

Accepted Solution

by:
Experienced Member earned 2000 total points
ID: 39945543
I use Excel (Office) 2010 on Windows 7 and the issue you describe above does not happen to me.

Try the following:

1. Try a completely new workbook, make a sample and test. Does the issue occur with a new workbook?  That is, is it a workbook file issue or is it an Excel issue.

2. If you think Excel is at fault, go to Programs and Features, click on Office, Change and Repair.  Allow Office to repair itself. Then make sure it is fully updated (2 service packs and all patches).  Test again.

3. If the above fail, try testing with a different Windows User Profile (Account). It could be a profile problem.
0
 
LVL 52

Expert Comment

by:Rgonzo1971
ID: 39945544
Hi,

How do you make the copy?

Regards
0
 

Author Comment

by:RNikolai001
ID: 39957706
Sorry for the delay. Out of town for work. I made a fresh workbook and made a copy both with the Copy Worksheet (right click on tab, choose "Move or Copy") and also copy and paste functions.  No issue on fresh workbook. At least I now know that it is not my entire Excel software that is malfunctioning. My daily cumulative worksheet with 2500 rows of data is the issue. I copy and paste solely from this cumulative work so somehow I need to figure out what is causing the odd formatting when I use either method for copying data from that "problem" worksheet.
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
LVL 49

Expert Comment

by:Martin Liss
ID: 40012494
I've requested that this question be deleted for the following reason:

The question has either no comments or not enough useful information to be called an "answer".
0
 

Author Closing Comment

by:RNikolai001
ID: 40012495
The problem is somewhere in my workbook and not in Excel 2010 overall. Thank you fir helping me deduce that much!
0
 
LVL 97

Expert Comment

by:Experienced Member
ID: 40012629
@RNikolai001 - Thank you for following up.
0

Featured Post

Manage your data center from practically anywhere

The KN8164V features HD resolution of 1920 x 1200, FIPS 140-2 with level 1 security standards and virtual media transmissions at twice the speed. Built for reliability, the KN series provides local console and remote over IP access, ensuring 24/7 availability to all servers.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Lately there has been a variety of news related to U.S. employment.  Stories about worker productivity, automobile and airline unions, low employment and foreign laborers have frequented the news.  Each story has good and bad attributes we might arg…
PaperPort has a feature called the "Send To Bar". It provides a convenient, drag-and-drop interface for using other installed software, such as Microsoft Office. However, this article shows that the latest Office 2016 apps (installed with an Office …
This video walks the viewer through the process of creating a watermark for their document, customizing it, and saving it for viewing/printing needs.
This video shows where to find the word count, how to display it, and what it breaks down to in Microsoft Word.
Suggested Courses

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question