RE: 2007 file saved as .xls prints wrong on computer w 2003 softwa

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



The customer receives the same excel reports from me every month and the
problem started when I installed 2007. Neither of us changed printers but
that was the first thing I asked.
In the meantime I sent the file to a local computer that still has 2003 so I
could see what customer is seeing - figured out what is going on. I always
use “autofit columns” formatted as accounting $ so of course I did the same
thing using the 2007 version. But when I opened the file using the 2003
Excel, it lost that formatting and the columns were wider than they should
have been. So that’s why my customer was complaining that the last column
didn’t fit on the page.
Of course, I have no clue why it loses the formatting (autofit) but at least
I know what’s happening to her. Thank you.


"Bruce Sinclair" wrote:

In article <DC2F6757-3F10-46D9-9BEB-1B3D57B64E51@xxxxxxxxxxxxx>, =?Utf-8?B?U2hhbmUgRGV2ZW5zaGlyZQ==?= <ShaneDevenshire@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
Are they using the Fit to Page option in Page Setup?

They'll have a different printer, right ? Get them to set their
spreadsheet up how they want it to print. All printers are different (eg
printable areas) ... and I suspect this is not actually your problem, but
theirs. :)


"bz" wrote:

My customers that still use Excel 2003 are complaining that my excel 2007
files (saved as .xls) don't print correctly - one problem is the last column
on the right falls off the page (creates a new page). I increased my left and

right margins and made sure the form fit on the page but when they get it, it

still doesn't fit on the page. This only started happening when I loaded the
2007 software.
I thought if I saved it as a 2003 file, it would continut to look the same
to a 2003 Excel user.
Anyone know what to do about this problem?
Tried to reinstall 2003 but get a "can't find a source" message.

.



Relevant Pages

  • Re: best Excel module
    ... formfeed paper printed on obselete line printers and delivered ... manually to printing them as PDF files delievered electronically. ... However, I am getting user complaints that the Excel files are ugly, ... without all the nice formatting that Excel supports. ...
    (comp.lang.perl.misc)
  • RE: 2007 file saved as .xls prints wrong on computer w 2003 softwa
    ... Neither of us changed printers but ... could see what customer is seeing - figured out what is going on. ... I have no clue why it loses the formatting but at least ... All printers are different (eg ...
    (microsoft.public.excel.misc)
  • Re: Major help needed - Iterative Functions
    ... If producing the final schedule cannot be automated on excel then such is ... going to retool and then compare the results to determine the best solution. ... So I have a table from which I know the products and dates the customer ...
    (microsoft.public.excel.programming)
  • Re: Major help needed - Iterative Functions
    ... MS Excel MVP ... My production schedule will be 40-80 lines long. ... going to retool and then compare the results to determine the best solution. ... So I have a table from which I know the products and dates the customer ...
    (microsoft.public.excel.programming)
  • RE: Major help needed - Iterative Functions
    ... Would there be a way of excel just outputting an optimised solution? ... that are the same as the urgent product, schedule them all together, then ... So I have a table from which I know the products and dates the customer ... From the production and tool change times required I can calculate ...
    (microsoft.public.excel.programming)