|
Related Topics:
| default font(size) in Comments - I would like to change the default font and fontsize used in Comments. Have found the setting in Windows but cannot find it in Office X (SR 1) for Mac. Help is Robert
New worksheets NOT default font size? - Hi, Just a quick question. I have my default font set at Verdana 12pt (in and new workbooks open with those settings ok. However, when I then add a new worksheet to the workbook, the font in the new sheet is 10pt (with the..
Change margins from inches to mm? - Does anybody know how to change the margins display in excel from inches to mm. There used to be an option within but I cannot see it anymore. Thanks Tony
Excel 10:How to set margins for Page Setup in inches in Ex.. - Dear all, How to set margins for Page Setup in inches in Excel 10 on Mac? In Word, we can go to and change the unit to inches, but in Excel there is no such option. How to change the margins units to inches in Excel 10?..
Just installed Leopard and now... - All of my Excel docs, even the default, have margins that are 4 inches wide by 3.5 inches high. Page setup says the sheet is US Letter (8.5 x 11). Any change in the page setup does not change the margins. I have opened up the on another..
|
|
|
Next: Excel: Data entry with List Wizard causing crash
|
| Author |
Message |
External

Since: Nov 30, 2007 Posts: 3
|
(Msg. 1) Posted: Fri Nov 30, 2007 3:18 pm
Post subject: Leopard document size set at 4 x 4 inches default Archived from groups: microsoft>public>mac>office>excel (more info?)
|
|
|
When I open a new document in excel 2004 the document opens up to a default
of 4 x 4 inches at 100% size even though all settings are set at letter size
(both in preferences and print settings) There seems to be no changing this.
When I open up an old documents they too are set at 4x4 inches even though
they used to open in letter size before the os 10.5.1 upgrade. I have tried
changing page views, preferences, installing new printer drivers, the new
office update and trashing .plist files. I have read other people have the
exact same problem but does anyone have a solution yet? (also won't print
preview properly).
Thanks >> Stay informed about: Leopard document size set at 4 x 4 inches default |
|
| Back to top |
|
 |  |
External

Since: Jul 20, 2005 Posts: 1719
|
(Msg. 2) Posted: Fri Nov 30, 2007 6:48 pm
Post subject: Re: Leopard document size set at 4 x 4 inches default [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
|
|
|
Have you checked for an updated driver for your printer since upgrading to
Leopard? That sounds like what's causing both problems.
HTH |:>)
Bob Jones
[MVP] Office:Mac
On 11/30/07 6:18 PM, in article
A09E6DA2-B86D-4B0B-8B17-B831B6826985 DeleteThis @microsoft.com, "sar"
<sar DeleteThis @discussions.microsoft.com> wrote:
> When I open a new document in excel 2004 the document opens up to a default
> of 4 x 4 inches at 100% size even though all settings are set at letter size
> (both in preferences and print settings) There seems to be no changing this.
> When I open up an old documents they too are set at 4x4 inches even though
> they used to open in letter size before the os 10.5.1 upgrade. I have tried
> changing page views, preferences, installing new printer drivers, the new
> office update and trashing .plist files. I have read other people have the
> exact same problem but does anyone have a solution yet? (also won't print
> preview properly).
>
> Thanks >> Stay informed about: Leopard document size set at 4 x 4 inches default |
|
| Back to top |
|
 |  |
External

Since: Nov 30, 2007 Posts: 3
|
(Msg. 3) Posted: Fri Nov 30, 2007 6:48 pm
Post subject: Re: Leopard document size set at 4 x 4 inches default [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
|
|
|
Yup have installed a new driver as well as the microsoft update
Thanks
"CyberTaz" wrote:
> Have you checked for an updated driver for your printer since upgrading to
> Leopard? That sounds like what's causing both problems.
>
> HTH |:>)
> Bob Jones
> [MVP] Office:Mac
>
>
>
> On 11/30/07 6:18 PM, in article
> A09E6DA2-B86D-4B0B-8B17-B831B6826985 RemoveThis @microsoft.com, "sar"
> <sar RemoveThis @discussions.microsoft.com> wrote:
>
> > When I open a new document in excel 2004 the document opens up to a default
> > of 4 x 4 inches at 100% size even though all settings are set at letter size
> > (both in preferences and print settings) There seems to be no changing this.
> > When I open up an old documents they too are set at 4x4 inches even though
> > they used to open in letter size before the os 10.5.1 upgrade. I have tried
> > changing page views, preferences, installing new printer drivers, the new
> > office update and trashing .plist files. I have read other people have the
> > exact same problem but does anyone have a solution yet? (also won't print
> > preview properly).
> >
> > Thanks
>
> >> Stay informed about: Leopard document size set at 4 x 4 inches default |
|
| Back to top |
|
 |  |
External

Since: Jul 20, 2005 Posts: 1719
|
(Msg. 4) Posted: Sat Dec 01, 2007 9:57 am
Post subject: Re: Leopard document size set at 4 x 4 inches default [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
|
|
|
Then I believe you'll need to furnish a bit more info as well as some
clarification of what the issues really are - see the interjections to your
op, below:
>> On 11/30/07 6:18 PM, in article
>> A09E6DA2-B86D-4B0B-8B17-B831B6826985.TakeThisOut@microsoft.com, "sar"
>> <sar.TakeThisOut@discussions.microsoft.com> wrote:
>>
>>> When I open a new document in excel 2004 the document opens up to a default
>>> of 4 x 4 inches at 100% size even though all settings are set at letter size
>>> (both in preferences and print settings) There seems to be no changing
>>> this.
Are you actually referring to the size of the file *window* when you open a
workbook? If so, that has nothing to do with printer settings, nor is there
a specific preference for window dimensions. Workbooks should reopen based
on whatever window size, position & zoom was in effect the last time the
file was saved before it was closed. It makes no difference what the paper
size, orientation, margins, etc. are set for.
>>> When I open up an old documents they too are set at 4x4 inches even though
>>> they used to open in letter size before the os 10.5.1 upgrade.
How did you go about upgrading to Leopard? I understand that there are a few
methods and which you used may have bearing on the results.
>>> I have tried
>>> changing page views, *preferences*,
Specifically ~what~ preferences are you referring to? Again, there are none
that regulate the size of the workbook window. Nor are there any
"preferences" [Excel> Preferences] for print settings - they're handled
through Page Setup.
>>>installing new printer drivers, the new
>>> office update and trashing *.plist files*.
Exactly what ".plist" files have you trashed - there are several prefs &
plist files used by Excel... And not all are stored in the same place.
>>>I have read other people have the
>>> exact same problem but does anyone have a solution yet? (also won't print
>>> preview properly).
I'm afraid "won't print preview properly" isn't very descriptive:-) What
specifically do you mean by that? This is probably a separate issue.
Although there have been a number of reported problems with Leopard upgrades
there really doesn't seem to be a common cause - and many have had no
problems at all. Unfortunately there are so many variables based on
individual installations that a universal "fix" doesn't appear to be likely.
You may wind up having to Remove Office & reinstall, but I'd wait for more
input before doing so.
Hopefully some others will have suggestions to offer as I haven't moved to
Leopard myself - am waiting until after the first of the year. Since I'm
still using Tiger I can't do any real investigation that may help you much
more, but the info requested above will be useful to anyone who can.
>>>
>>> Thanks
Regards |:>)
Bob Jones
[MVP] Office:Mac >> Stay informed about: Leopard document size set at 4 x 4 inches default |
|
| Back to top |
|
 |  |
External

Since: Dec 02, 2007 Posts: 2
|
(Msg. 5) Posted: Sun Dec 02, 2007 1:12 am
Post subject: Re: Leopard document size set at 4 x 4 inches default [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
|
|
|
The same problem here.
After installing Leopard (10.5.1) and upgrading to Excel / Office
(11.3.6)
Pages new and old open up in 4x4 (in my case 12cmx12cm)
(re) Setting the 'page setup' doesn't effect the document.
Wheter it's set to A4 or Letter, the size remains the same.
Even my standard lay-out, that i've been using for year's, open up in
this wrong format.
Instead of 1 page, the document is spread over 9 pages.
Resetting the page break's doesn't solve the problem, since the
'fysical' sice of the document doesn't chance.
The problem is not related to a printer driver. I use the 'any
prinrter' option. And it also shows in 'page break preview', 'page
layout', 'print preview' and 'print to PDF'.
So in short the problem is the system only 'knows' a 4x4 document and
that can't be changed. >> Stay informed about: Leopard document size set at 4 x 4 inches default |
|
| Back to top |
|
 |  |
External

Since: Dec 02, 2007 Posts: 2
|
(Msg. 6) Posted: Sun Dec 02, 2007 1:21 am
Post subject: Re: Leopard document size set at 4 x 4 inches default [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
|
|
|
|
|
| Back to top |
|
 |  |
External

Since: Mar 07, 2004 Posts: 3826
|
(Msg. 7) Posted: Mon Dec 03, 2007 8:30 am
Post subject: Re: Leopard document size set at 4 x 4 inches default [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
|
|
|
In article
<4b7e8e6a-612e-4579-9ce9-ddeca7775184 RemoveThis @y5g2000hsf.googlegroups.com>,
boris.klatser RemoveThis @gmail.com wrote:
> The same problem here.
> After installing Leopard (10.5.1) and upgrading to Excel / Office
> (11.3.6)
>
> Pages new and old open up in 4x4 (in my case 12cmx12cm)
>
> (re) Setting the 'page setup' doesn't effect the document.
> Wheter it's set to A4 or Letter, the size remains the same.
> Even my standard lay-out, that i've been using for year's, open up in
> this wrong format.
> Instead of 1 page, the document is spread over 9 pages.
> Resetting the page break's doesn't solve the problem, since the
> 'fysical' sice of the document doesn't chance.
Your terminology is somewhat confusing to me - "open up" to me implies
what the file window looks like on screen - which has nothing to do with
printing. Neither does "wrong format", really.
If the problem is *only* printing, what did you do when "Setting the
'page setup'"? What is the scaling set to in Page Setup? If you click
Options, what is the Paper Size that's listed? What are the Margins set
to?
> The problem is not related to a printer driver. I use the 'any
> prinrter' option. And it also shows in 'page break preview', 'page
> layout', 'print preview' and 'print to PDF'.
Does it change when you use the correct driver for your printer? Page
Break Preview, Page Layout and Print to PDF all *should* look exactly
the same as your physical print out, since they all use the system print
driver.
> So in short the problem is the system only 'knows' a 4x4 document and
> that can't be changed.
What about other Office apps - any strange printing with them? >> Stay informed about: Leopard document size set at 4 x 4 inches default |
|
| Back to top |
|
 |  |
External

Since: Mar 07, 2004 Posts: 3826
|
(Msg. 8) Posted: Mon Dec 03, 2007 8:34 am
Post subject: Re: Leopard document size set at 4 x 4 inches default [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
|
|
|
In article
<bfbb46a5-fdae-4a42-9554-93397b95312f.DeleteThis@e67g2000hsc.googlegroups.com>,
boris.klatser.DeleteThis@gmail.com wrote:
> PS I allready tried to Remove Office & reinstall, that din't solve the
> problem. (this is on my MacBook Pro)
Yeah, that's almost always a waste of time. Mac applications just don't
corrupt that frequently (neither do Windows apps, but reinstalling often
resets their registry settings). Almost all strangeness due to
corruption in Office apps occurs in the Preferences. Heavily edited docs
can get corrupted, too, but that wouldn't affect new docs.
> Installing Office on my G5, also under Leopard, had the same effect =
> 4x4 pages.
> To continue working i'm now have to switch to 'numbers' a lot of
> hassle...... >> Stay informed about: Leopard document size set at 4 x 4 inches default |
|
| Back to top |
|
 |  |
External

Since: Nov 30, 2007 Posts: 3
|
(Msg. 9) Posted: Mon Dec 03, 2007 8:54 am
Post subject: Re: Leopard document size set at 4 x 4 inches default [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
|
|
|
Hi,
I was talking about document size, not window size. I have tried changing
the document size in page set-up and in the printer preferences. I have
done all updates including software, os and printer drivers. The plist files
I dumped were in the user library under MS. What seemed to work
temporarily was trashing all files related to the brother controlcentre2 (a
program which is installed during my printer/scanner update, I have a Brother
MFC 420CN Printer/Scanner and Brother issued a 10.5 update recently) After I
trashed all the files related to the controlcentre2 documents started to open
properly at letter size (again not talking about window size). So I saved
all my current excel documents at letter size, but now when I open excel,
everything goes back to 4x4inch. I haven't touched or added anything since
last time I opened the files, no printer additions, nothing.
Sar
"CyberTaz" wrote:
> Then I believe you'll need to furnish a bit more info as well as some
> clarification of what the issues really are - see the interjections to your
> op, below:
>
> >> On 11/30/07 6:18 PM, in article
> >> A09E6DA2-B86D-4B0B-8B17-B831B6826985 RemoveThis @microsoft.com, "sar"
> >> <sar RemoveThis @discussions.microsoft.com> wrote:
> >>
> >>> When I open a new document in excel 2004 the document opens up to a default
> >>> of 4 x 4 inches at 100% size even though all settings are set at letter size
> >>> (both in preferences and print settings) There seems to be no changing
> >>> this.
>
> Are you actually referring to the size of the file *window* when you open a
> workbook? If so, that has nothing to do with printer settings, nor is there
> a specific preference for window dimensions. Workbooks should reopen based
> on whatever window size, position & zoom was in effect the last time the
> file was saved before it was closed. It makes no difference what the paper
> size, orientation, margins, etc. are set for.
>
> >>> When I open up an old documents they too are set at 4x4 inches even though
> >>> they used to open in letter size before the os 10.5.1 upgrade.
>
> How did you go about upgrading to Leopard? I understand that there are a few
> methods and which you used may have bearing on the results.
>
> >>> I have tried
> >>> changing page views, *preferences*,
>
> Specifically ~what~ preferences are you referring to? Again, there are none
> that regulate the size of the workbook window. Nor are there any
> "preferences" [Excel> Preferences] for print settings - they're handled
> through Page Setup.
>
> >>>installing new printer drivers, the new
> >>> office update and trashing *.plist files*.
>
> Exactly what ".plist" files have you trashed - there are several prefs &
> plist files used by Excel... And not all are stored in the same place.
>
> >>>I have read other people have the
> >>> exact same problem but does anyone have a solution yet? (also won't print
> >>> preview properly).
>
> I'm afraid "won't print preview properly" isn't very descriptive:-) What
> specifically do you mean by that? This is probably a separate issue.
>
> Although there have been a number of reported problems with Leopard upgrades
> there really doesn't seem to be a common cause - and many have had no
> problems at all. Unfortunately there are so many variables based on
> individual installations that a universal "fix" doesn't appear to be likely.
> You may wind up having to Remove Office & reinstall, but I'd wait for more
> input before doing so.
>
> Hopefully some others will have suggestions to offer as I haven't moved to
> Leopard myself - am waiting until after the first of the year. Since I'm
> still using Tiger I can't do any real investigation that may help you much
> more, but the info requested above will be useful to anyone who can.
>
> >>>
> >>> Thanks
>
> Regards |:>)
> Bob Jones
> [MVP] Office:Mac
>
> >> Stay informed about: Leopard document size set at 4 x 4 inches default |
|
| Back to top |
|
 |  |
External

Since: Apr 06, 2006 Posts: 692
|
(Msg. 10) Posted: Mon Dec 03, 2007 12:29 pm
Post subject: Re: Leopard document size set at 4 x 4 inches default [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
|
|
|
Okay - that narrows it down quite a bit:-)
Since the removal of the Brother software rectified the problem - even tough
temporarily - it suggests that the problem lies there. Keep in mind that
Excel simply supplies data to & receives instructions from the OS print
services & the driver software, so it is not likely to be the culprit here -
especially if the Excel prefs you deleted made no difference. The changes
from 10.5 to 10.5.1 may have outrun the Brother update, so I'd suggest
checking along that route again to see if yet another might be available or
if Brother support is having similar reports from other users.
--
Regards |:>)
Bob Jones
[MVP] Office:Mac
"sar" <sar.TakeThisOut@discussions.microsoft.com> wrote in message
news:01A1D225-66E3-47B2-B809-CD47D9A915B5@microsoft.com...
> Hi,
>
> I was talking about document size, not window size. I have tried changing
> the document size in page set-up and in the printer preferences. I have
> done all updates including software, os and printer drivers. The plist
> files
> I dumped were in the user library under MS. What seemed to work
> temporarily was trashing all files related to the brother controlcentre2
> (a
> program which is installed during my printer/scanner update, I have a
> Brother
> MFC 420CN Printer/Scanner and Brother issued a 10.5 update recently)
> After I
> trashed all the files related to the controlcentre2 documents started to
> open
> properly at letter size (again not talking about window size). So I saved
> all my current excel documents at letter size, but now when I open excel,
> everything goes back to 4x4inch. I haven't touched or added anything
> since
> last time I opened the files, no printer additions, nothing.
>
> Sar
>
> "CyberTaz" wrote:
>
>> Then I believe you'll need to furnish a bit more info as well as some
>> clarification of what the issues really are - see the interjections to
>> your
>> op, below:
>>
>> >> On 11/30/07 6:18 PM, in article
>> >> A09E6DA2-B86D-4B0B-8B17-B831B6826985.TakeThisOut@microsoft.com, "sar"
>> >> <sar.TakeThisOut@discussions.microsoft.com> wrote:
>> >>
>> >>> When I open a new document in excel 2004 the document opens up to a
>> >>> default
>> >>> of 4 x 4 inches at 100% size even though all settings are set at
>> >>> letter size
>> >>> (both in preferences and print settings) There seems to be no
>> >>> changing
>> >>> this.
>>
>> Are you actually referring to the size of the file *window* when you open
>> a
>> workbook? If so, that has nothing to do with printer settings, nor is
>> there
>> a specific preference for window dimensions. Workbooks should reopen
>> based
>> on whatever window size, position & zoom was in effect the last time the
>> file was saved before it was closed. It makes no difference what the
>> paper
>> size, orientation, margins, etc. are set for.
>>
>> >>> When I open up an old documents they too are set at 4x4 inches even
>> >>> though
>> >>> they used to open in letter size before the os 10.5.1 upgrade.
>>
>> How did you go about upgrading to Leopard? I understand that there are a
>> few
>> methods and which you used may have bearing on the results.
>>
>> >>> I have tried
>> >>> changing page views, *preferences*,
>>
>> Specifically ~what~ preferences are you referring to? Again, there are
>> none
>> that regulate the size of the workbook window. Nor are there any
>> "preferences" [Excel> Preferences] for print settings - they're handled
>> through Page Setup.
>>
>> >>>installing new printer drivers, the new
>> >>> office update and trashing *.plist files*.
>>
>> Exactly what ".plist" files have you trashed - there are several prefs &
>> plist files used by Excel... And not all are stored in the same place.
>>
>> >>>I have read other people have the
>> >>> exact same problem but does anyone have a solution yet? (also won't
>> >>> print
>> >>> preview properly).
>>
>> I'm afraid "won't print preview properly" isn't very descriptive:-) What
>> specifically do you mean by that? This is probably a separate issue.
>>
>> Although there have been a number of reported problems with Leopard
>> upgrades
>> there really doesn't seem to be a common cause - and many have had no
>> problems at all. Unfortunately there are so many variables based on
>> individual installations that a universal "fix" doesn't appear to be
>> likely.
>> You may wind up having to Remove Office & reinstall, but I'd wait for
>> more
>> input before doing so.
>>
>> Hopefully some others will have suggestions to offer as I haven't moved
>> to
>> Leopard myself - am waiting until after the first of the year. Since I'm
>> still using Tiger I can't do any real investigation that may help you
>> much
>> more, but the info requested above will be useful to anyone who can.
>>
>> >>>
>> >>> Thanks
>>
>> Regards |:>)
>> Bob Jones
>> [MVP] Office:Mac
>>
>> >> Stay informed about: Leopard document size set at 4 x 4 inches default |
|
| Back to top |
|
 |  |
External

Since: Mar 19, 2008 Posts: 1
|
(Msg. 11) Posted: Wed Mar 19, 2008 6:27 pm
Post subject: Re: Leopard document size set at 4 x 4 inches default [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
|
|
|
|
|
| Back to top |
|
 |  |
|