Weird Excel problem only happens on a Mac - ehMac.ca
Facebook
Twitter
YouTube
Register FAQ Members List Calendar Search Today's Posts Mark Forums Read


Reply
 
LinkBack Thread Tools Display Modes
Old Apr 8th, 2006, 09:59 AM   #1
Full Citizen
 
Ariell's Avatar
 
Join Date: Mar 2005
Location: Toronto
Posts: 264
Weird Excel problem only happens on a Mac

Hi

I have a spreadsheet that was created by a company I work for to bill for expenses. On one page, you input all your expenses and then the last page does a subtotal and total. This used to work fine. Now, the subtotal and total cells on the last page look fine onscreen (they have the correct figures) but in print preview and more importantly, when actually printing the document, those cells and any other cells that have an equation programmed have ########### in them. The subtotal on the first page (where the expenses are input) however prints fine. It's only on the last page that this happens.

I can't figure out what's going on. Like I said, this used to work before I upgraded Office (from X to 10.1.6). That's the only thing that I can think of that's changed. Also, I've tried the same document on 2 PCs and it looks and prints fine on them.

Any thoughts? Thanks.
Ariell is offline   Reply With Quote
Sponsored Links
Advertisement
 
Old Apr 8th, 2006, 10:32 AM   #2
Full Citizen
 
teeterboy3's Avatar
 
Join Date: May 2005
Location: London… the Canada one.
Posts: 898
Send a message via AIM to teeterboy3 Send a message via MSN to teeterboy3 Send a message via Yahoo to teeterboy3
The ###### signs indicate that the column isn't wide enough to display the data contained in it. If you double-click the right boundary of the column it will expand the column to display the data that is contained within.

I am not sure if that is what you are talking about, but hopefully…
teeterboy3 is offline   Reply With Quote
Old Apr 8th, 2006, 12:58 PM   #3
Full Citizen
 
Ariell's Avatar
 
Join Date: Mar 2005
Location: Toronto
Posts: 264
Thanks teeterboy, but that doesn't seem to be the problem.

The cell is easily 2x the size of the total, but i did try to resize it and it still shows #######. Also tried resizing the font. No luck.

The weird thing is too, that I went back and opened up 2 other invoices that I printed out fine in the past and now when I open them, the same thing happens. Onscreen, the correct totals show up fine but in print preview or when I actually print the invoice, ###### shows up in those cells.
Ariell is offline   Reply With Quote
Old Apr 8th, 2006, 03:17 PM   #4
krs
Honourable Citizen
 
krs's Avatar
 
Join Date: Mar 2005
Location: Ontario and Quebec
Posts: 8,424
I have this happening with Excel on occasion - the software seems to be a bit flaky in that respect.
In my cases, it always ended up being a problem with the width of the cell as teetherboy mentioned. Sometimes you could fix it by making the column wider or change the font, othertimes you needed to go in and reformat the cell parameters - they somehow changed from a number with two decimal places, which is what I normally use for currency, to something else.
krs is offline   Reply With Quote
Old Apr 8th, 2006, 04:02 PM   #5
Full Citizen
 
teeterboy3's Avatar
 
Join Date: May 2005
Location: London… the Canada one.
Posts: 898
Send a message via AIM to teeterboy3 Send a message via MSN to teeterboy3 Send a message via Yahoo to teeterboy3
I will also add that my boss was having a similar problem on the XP version too. Only on him it was giving those little green triangle warnings in the top left hand corner and an error about the format being switched from numbers to text or something… anyway it seems like there's some sort of bug in that respect.
teeterboy3 is offline   Reply With Quote
Old Apr 9th, 2006, 10:53 AM   #6
Full Citizen
 
Ariell's Avatar
 
Join Date: Mar 2005
Location: Toronto
Posts: 264
Seems to be a problem tied to the version (10.1.6). I tried opening the exact same files with Excel 2004 and it looks and prints fine. Weird.
Ariell is offline   Reply With Quote
Old Apr 9th, 2006, 11:02 AM   #7
Full Citizen
 
Join Date: Jan 2004
Location: Silverton, BC
Posts: 846
Send a message via AIM to duosonic
also check the formulae – & reset the reference cells, and check the formatting (ie, text or numerals, etc). Happens sometimes.
__________________
MacBookPro 13" 2.7 GHz Intel Core i7
Mainline Graphics & Communications ~ graphic design, business support services ~ Computer Tutoring: obedience training for you & your computer
duosonic is offline   Reply With Quote
Old Apr 9th, 2006, 11:26 AM   #8
Full Citizen
 
Ariell's Avatar
 
Join Date: Mar 2005
Location: Toronto
Posts: 264
Thanks duosonic, but I really don't think that it's a formatting or formula issue otherwise why would the exact same document on the exact same computer be perfectly fine on 11.2 and not on 10.1.6?

Plus, I didn't create the document. It was created by a company that I do some contract work for so I think technically I'm not supposed to monkeying around with the programming. Plus when I did take a look at the formula, it was way too hugely complicated!

But like I said 11.2 works just fine.
Ariell is offline   Reply With Quote
Reply

Thread Tools
Display Modes

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 Off
Pingbacks are Off
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
weird iTunes problem sketch Mac, iPhone, iPad and iPod Help & Troubleshooting 2 Mar 15th, 2006 09:30 PM
Canon A70 Mac USB transfer problem MacAndy Mac, iPhone, iPad and iPod Help & Troubleshooting 14 Nov 30th, 2005 04:04 PM
Really weird iBook problem! Ingenu Mac, iPhone, iPad and iPod Help & Troubleshooting 8 Sep 9th, 2005 09:30 AM
Mac Mini as Media Center review da_jonesy Anything Mac 3 May 16th, 2005 03:12 PM
excel problem! däycüs mäximüs Mac, iPhone, iPad and iPod Help & Troubleshooting 0 Feb 14th, 2003 11:14 PM


All times are GMT -4. The time now is 11:51 AM.



Copyright © 1999 - 2012, ehMac.ca All rights reserved. ehMac is not affiliated with Apple Inc. Mac, iPod, iTunes, iPhone, Apple TV are trademarks of Apple Inc. Content Relevant URLs by vBSEO 3.6.0 RC 2

Tribe.ca: Urban living in Toronto!