New To Mac-Forums?

Welcome to our community! Join the discussion today by registering your FREE account. If you have any problems with the registration process, please contact us!

Get your questions answered by community gurus Advice and insight from world-class Apple enthusiasts Exclusive access to members-only contests, giveaways and deals

Join today!

 
Start a Discussion
 

Mac-Forums Brief

Subscribe to Mac-Forums Brief to receive special offers from Mac-Forums partners and sponsors

Join the conversation RSS
OS X - Apps and Games Discussion of applications and games available for Mac OS X.

Exported XLS files turning RED


Post Reply New Thread Subscribe

 
Thread Tools
horizon180

 
Member Since: Feb 02, 2010
Posts: 3
horizon180 is on a distinguished road

horizon180 is offline
Hi there.

My office is in the process of switching from PC to Mac. There are 15 of us, and 5 have now made the switch, but a lot of the company documents and templates remain in MS Office formats.

This seems like it might be a small export error somewhere, but this is what I am facing:

On the Mac
1. Open XLS document template (with macros) in Numbers.
2. Edit document.
3. Export to XLS file.
4. Email XLS file to a PC.

On the PC
5. Open above XLS file in Excel, works fine, start editing.
6. During the edit process, if you copy a sheet to a new sheet or new book, Excel goes and changes all cells that didn't have a background colour (90% of the sheet), into having a RED background.
7. This problem is not local. When repeated through Numbers on the other Macs in the office, the above porting causes the sheet background to turn RED in Excel on all PCs in the office.

I cannot find any references to this on Mac Forums, so I am writing a new thread. Apologies (in advance) if there is already a thread with the same problem that I just couldn't find.

Looking for a solution, haste appreciated.

Thank you.

H180
QUOTE Thanks
chscag

 
chscag's Avatar
 
Member Since: Jan 23, 2008
Location: Fort Worth, Texas
Posts: 38,429
chscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond repute
Mac Specs: 27" iMac i5, 3.2 GHz, iPad 3, iPhone 5c, 3 iPods, OS X Mavericks

chscag is offline
Quote:
On the Mac
1. Open XLS document template (with macros) in Numbers.
2. Edit document.
3. Export to XLS file.
4. Email XLS file to a PC.
How were the Excel XLS documents originally created? PC MS Office or Mac MS Office? Sorry, but I can't seem to follow what you're doing to move XLS sheets from a PC to the Mac. And why use iWork Numbers to open the documents to edit them and then email them back to a PC?

You did say you were switching to Macs? That's why what you've done above is a bit confusing.

Regards.
QUOTE Thanks
horizon180

 
Member Since: Feb 02, 2010
Posts: 3
horizon180 is on a distinguished road

horizon180 is offline
Sorry for not being too clear.
On the Mac, I (personally) am not running Office for Mac, only iWorks (for now).

The document I am editing, is a monthly update document where I need to update several sheets within one book, for accounts and so on, was made on MS Office on a PC. The office manager who then "manages" my monthly statements, copies sheets from my document into a separate central Excel file for record keeping and account management.

Hence the need to copy sheets from one XLS document (created on MS Office on a PC, edited on Numbers) into a separate XLS document (created on MS Office on a PC, edited in Excel on a PC).

Is that any clearer?
QUOTE Thanks
chscag

 
chscag's Avatar
 
Member Since: Jan 23, 2008
Location: Fort Worth, Texas
Posts: 38,429
chscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond repute
Mac Specs: 27" iMac i5, 3.2 GHz, iPad 3, iPhone 5c, 3 iPods, OS X Mavericks

chscag is offline
OK, I understand what you're doing. Thanks for posting back.

As for the red background of the sheets, I haven't tried to duplicate the problem as I do not have iWork. I'm using Office 2008 on the Mac and Office 2007 on the PC and have not run into that anomaly.

What I suggest is posting this same question to the MS Mac Office forum specifically to the Excel folks. Very helpful folks hang out there. I use that forum myself often when I have Office problems.

Here is the LINK

I hate to put you off somewhere else, but this is one I have never run into.

Regards.
QUOTE Thanks
horizon180

 
Member Since: Feb 02, 2010
Posts: 3
horizon180 is on a distinguished road

horizon180 is offline
Quote:
Originally Posted by chscag View Post
Here is the LINK
Thank you for your help and the link. I have posted the issue on the Excel Forums there and will be eagerly awaiting a reply. As you can imagine, this is a really peculiar problem, one that has forced me to for the first time in over 4 years of using a Mac, to post an entry on the Mac Forums.

Thanks again,

H180
QUOTE Thanks

Post Reply New Thread Subscribe


« iWork Pages problem | Iwork pages template with a auto update date »
Thread Tools

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off
Forum Jump

Similar Threads
Thread
Thread Starter
Forum
Replies
Last Post
What are some of your favorite song lyrics? D3v1L80Y Schweb's Lounge 69 08-26-2009 02:34 AM
Why are files renamed to unix and how to fix it hollinger OS X - Operating System 0 02-18-2009 06:14 AM

All times are GMT -4. The time now is 09:59 AM.

Powered by vBulletin
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
X

Welcome to Mac-Forums.com

Create your username to jump into the discussion!

New members like you have made this community the ultimate source for your Mac since 2003!


(4 digit year)

Already a member?