Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Spreadsheet View Issue XP and 2003 versions
On a series of spreadsheets I can see from A1 to N29 (14 Columns) on 100%
view (XP), however one of my users can see from A1 to EE29 (109 Columns) (so it is very condensed), also on 100% view (2003). The print preview is also mis-aligned. This is only an issue on about 20 spreadsheets, of similar layout, others are fine. If the user views the problem series on other machines then they are fine. There is nothing obvious in preferences, and the other workbooks are ok. My screen is 15 at 1280 x 960; the user has a 17 at 1290 x 1024. I appreciate that you would see more on a larger screen, but not to the point that the screen can not be worked with. The user with the issue is seeing 109 columns, whereas I see 14. I would not expect that much difference to the working screen. Ive changed the monitor twice, once to an identical 17 monitor, and once to another 17 model. Each time the spreadsheet view is compressed. The spreadsheets in question were working fine up until 30 June, when the used went on holiday, an on their return on 08 July the view was causing problems. No other issues with this user account or system. Kind regards Iain Stedman |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Spreadsheet View Issue XP and 2003 versions
Hi Iain,
Sounds like the windows font sizes (dpi) are different. In XP goto control panel display properties, the general tab. Check the DPI setting in the top drop down box. 96 dpi is normal. John "iains" wrote in message ... On a series of spreadsheets I can see from A1 to N29 (14 Columns) on 100% view (XP), however one of my users can see from A1 to EE29 (109 Columns) (so it is very condensed), also on 100% view (2003). The print preview is also mis-aligned. This is only an issue on about 20 spreadsheets, of similar layout, others are fine. If the user views the problem series on other machines then they are fine. There is nothing obvious in preferences, and the other workbooks are ok. My screen is 15 at 1280 x 960; the user has a 17 at 1290 x 1024. I appreciate that you would see more on a larger screen, but not to the point that the screen can not be worked with. The user with the issue is seeing 109 columns, whereas I see 14. I would not expect that much difference to the working screen. Ive changed the monitor twice, once to an identical 17 monitor, and once to another 17 model. Each time the spreadsheet view is compressed. The spreadsheets in question were working fine up until 30 June, when the used went on holiday, an on their return on 08 July the view was causing problems. No other issues with this user account or system. Kind regards Iain Stedman |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Spreadsheet View Issue XP and 2003 versions
Hi John
Thanks for the suggestion I've checked both monitors, and they are both 96dpi. Some newer spreadsheets, created since 08 July 2009, are showing ok, but everything before that date is an issue on that particular machine. Kind regards Iain "jaf" wrote: Hi Iain, Sounds like the windows font sizes (dpi) are different. In XP goto control panel display properties, the general tab. Check the DPI setting in the top drop down box. 96 dpi is normal. John "iains" wrote in message ... On a series of spreadsheets I can see from A1 to N29 (14 Columns) on 100% view (XP), however one of my users can see from A1 to EE29 (109 Columns) (so it is very condensed), also on 100% view (2003). The print preview is also mis-aligned. This is only an issue on about 20 spreadsheets, of similar layout, others are fine. If the user views the problem series on other machines then they are fine. There is nothing obvious in preferences, and the other workbooks are ok. My screen is 15 at 1280 x 960; the user has a 17 at 1290 x 1024. I appreciate that you would see more on a larger screen, but not to the point that the screen can not be worked with. The user with the issue is seeing 109 columns, whereas I see 14. I would not expect that much difference to the working screen. Ive changed the monitor twice, once to an identical 17 monitor, and once to another 17 model. Each time the spreadsheet view is compressed. The spreadsheets in question were working fine up until 30 June, when the used went on holiday, an on their return on 08 July the view was causing problems. No other issues with this user account or system. Kind regards Iain Stedman |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Spreadsheet View Issue XP and 2003 versions
Hi Iain,
Are there any macros in these workbooks? John "iains" wrote in message ... Hi John Thanks for the suggestion I've checked both monitors, and they are both 96dpi. Some newer spreadsheets, created since 08 July 2009, are showing ok, but everything before that date is an issue on that particular machine. Kind regards Iain "jaf" wrote: Hi Iain, Sounds like the windows font sizes (dpi) are different. In XP goto control panel display properties, the general tab. Check the DPI setting in the top drop down box. 96 dpi is normal. John "iains" wrote in message ... On a series of spreadsheets I can see from A1 to N29 (14 Columns) on 100% view (XP), however one of my users can see from A1 to EE29 (109 Columns) (so it is very condensed), also on 100% view (2003). The print preview is also mis-aligned. This is only an issue on about 20 spreadsheets, of similar layout, others are fine. If the user views the problem series on other machines then they are fine. There is nothing obvious in preferences, and the other workbooks are ok. My screen is 15 at 1280 x 960; the user has a 17 at 1290 x 1024. I appreciate that you would see more on a larger screen, but not to the point that the screen can not be worked with. The user with the issue is seeing 109 columns, whereas I see 14. I would not expect that much difference to the working screen. Ive changed the monitor twice, once to an identical 17 monitor, and once to another 17 model. Each time the spreadsheet view is compressed. The spreadsheets in question were working fine up until 30 June, when the used went on holiday, an on their return on 08 July the view was causing problems. No other issues with this user account or system. Kind regards Iain Stedman |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Spreadsheet View Issue XP and 2003 versions
Hi John
There are no macros in the spreadsheet. Iain "jaf" wrote: Hi Iain, Are there any macros in these workbooks? John "iains" wrote in message ... Hi John Thanks for the suggestion I've checked both monitors, and they are both 96dpi. Some newer spreadsheets, created since 08 July 2009, are showing ok, but everything before that date is an issue on that particular machine. Kind regards Iain "jaf" wrote: Hi Iain, Sounds like the windows font sizes (dpi) are different. In XP goto control panel display properties, the general tab. Check the DPI setting in the top drop down box. 96 dpi is normal. John "iains" wrote in message ... On a series of spreadsheets I can see from A1 to N29 (14 Columns) on 100% view (XP), however one of my users can see from A1 to EE29 (109 Columns) (so it is very condensed), also on 100% view (2003). The print preview is also mis-aligned. This is only an issue on about 20 spreadsheets, of similar layout, others are fine. If the user views the problem series on other machines then they are fine. There is nothing obvious in preferences, and the other workbooks are ok. My screen is 15 at 1280 x 960; the user has a 17 at 1290 x 1024. I appreciate that you would see more on a larger screen, but not to the point that the screen can not be worked with. The user with the issue is seeing 109 columns, whereas I see 14. I would not expect that much difference to the working screen. Ive changed the monitor twice, once to an identical 17 monitor, and once to another 17 model. Each time the spreadsheet view is compressed. The spreadsheets in question were working fine up until 30 June, when the used went on holiday, an on their return on 08 July the view was causing problems. No other issues with this user account or system. Kind regards Iain Stedman |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Spreadsheet View Issue XP and 2003 versions
Hi Iain,
The only other thing I would suggest is changing the monitor resolution on both machines to 1024 x 768 and see if they both look the same. It may be video driver related. John "iains" wrote in message ... Hi John There are no macros in the spreadsheet. Iain "jaf" wrote: Hi Iain, Are there any macros in these workbooks? John "iains" wrote in message ... Hi John Thanks for the suggestion I've checked both monitors, and they are both 96dpi. Some newer spreadsheets, created since 08 July 2009, are showing ok, but everything before that date is an issue on that particular machine. Kind regards Iain "jaf" wrote: Hi Iain, Sounds like the windows font sizes (dpi) are different. In XP goto control panel display properties, the general tab. Check the DPI setting in the top drop down box. 96 dpi is normal. John "iains" wrote in message ... On a series of spreadsheets I can see from A1 to N29 (14 Columns) on 100% view (XP), however one of my users can see from A1 to EE29 (109 Columns) (so it is very condensed), also on 100% view (2003). The print preview is also mis-aligned. This is only an issue on about 20 spreadsheets, of similar layout, others are fine. If the user views the problem series on other machines then they are fine. There is nothing obvious in preferences, and the other workbooks are ok. My screen is 15 at 1280 x 960; the user has a 17 at 1290 x 1024. I appreciate that you would see more on a larger screen, but not to the point that the screen can not be worked with. The user with the issue is seeing 109 columns, whereas I see 14. I would not expect that much difference to the working screen. Ive changed the monitor twice, once to an identical 17 monitor, and once to another 17 model. Each time the spreadsheet view is compressed. The spreadsheets in question were working fine up until 30 June, when the used went on holiday, an on their return on 08 July the view was causing problems. No other issues with this user account or system. Kind regards Iain Stedman |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Spreadsheet View Issue XP and 2003 versions
Hi John
I've hanged the resolution to 1024 x 768, with no change. I've checked for new drivers, but there is nothing newer than I have. Thanks for your suggestions. Kind regards Iain "jaf" wrote: Hi Iain, The only other thing I would suggest is changing the monitor resolution on both machines to 1024 x 768 and see if they both look the same. It may be video driver related. John "iains" wrote in message ... Hi John There are no macros in the spreadsheet. Iain "jaf" wrote: Hi Iain, Are there any macros in these workbooks? John "iains" wrote in message ... Hi John Thanks for the suggestion I've checked both monitors, and they are both 96dpi. Some newer spreadsheets, created since 08 July 2009, are showing ok, but everything before that date is an issue on that particular machine. Kind regards Iain "jaf" wrote: Hi Iain, Sounds like the windows font sizes (dpi) are different. In XP goto control panel display properties, the general tab. Check the DPI setting in the top drop down box. 96 dpi is normal. John "iains" wrote in message ... On a series of spreadsheets I can see from A1 to N29 (14 Columns) on 100% view (XP), however one of my users can see from A1 to EE29 (109 Columns) (so it is very condensed), also on 100% view (2003). The print preview is also mis-aligned. This is only an issue on about 20 spreadsheets, of similar layout, others are fine. If the user views the problem series on other machines then they are fine. There is nothing obvious in preferences, and the other workbooks are ok. My screen is 15 at 1280 x 960; the user has a 17 at 1290 x 1024. I appreciate that you would see more on a larger screen, but not to the point that the screen can not be worked with. The user with the issue is seeing 109 columns, whereas I see 14. I would not expect that much difference to the working screen. Ive changed the monitor twice, once to an identical 17 monitor, and once to another 17 model. Each time the spreadsheet view is compressed. The spreadsheets in question were working fine up until 30 June, when the used went on holiday, an on their return on 08 July the view was causing problems. No other issues with this user account or system. Kind regards Iain Stedman |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Spreadsheet View Issue XP and 2003 versions
Further to setting both machines to 1024 x 768, I have now logged in on the
other machine, and I can see the sheets with no issue. Would this suggest that there is something in his settings. Kind regards Iain "jaf" wrote: Hi Iain, The only other thing I would suggest is changing the monitor resolution on both machines to 1024 x 768 and see if they both look the same. It may be video driver related. John "iains" wrote in message ... Hi John There are no macros in the spreadsheet. Iain "jaf" wrote: Hi Iain, Are there any macros in these workbooks? John "iains" wrote in message ... Hi John Thanks for the suggestion I've checked both monitors, and they are both 96dpi. Some newer spreadsheets, created since 08 July 2009, are showing ok, but everything before that date is an issue on that particular machine. Kind regards Iain "jaf" wrote: Hi Iain, Sounds like the windows font sizes (dpi) are different. In XP goto control panel display properties, the general tab. Check the DPI setting in the top drop down box. 96 dpi is normal. John "iains" wrote in message ... On a series of spreadsheets I can see from A1 to N29 (14 Columns) on 100% view (XP), however one of my users can see from A1 to EE29 (109 Columns) (so it is very condensed), also on 100% view (2003). The print preview is also mis-aligned. This is only an issue on about 20 spreadsheets, of similar layout, others are fine. If the user views the problem series on other machines then they are fine. There is nothing obvious in preferences, and the other workbooks are ok. My screen is 15 at 1280 x 960; the user has a 17 at 1290 x 1024. I appreciate that you would see more on a larger screen, but not to the point that the screen can not be worked with. The user with the issue is seeing 109 columns, whereas I see 14. I would not expect that much difference to the working screen. Ive changed the monitor twice, once to an identical 17 monitor, and once to another 17 model. Each time the spreadsheet view is compressed. The spreadsheets in question were working fine up until 30 June, when the used went on holiday, an on their return on 08 July the view was causing problems. No other issues with this user account or system. Kind regards Iain Stedman |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Spreadsheet View Issue XP and 2003 versions
Hi Iain,
I would suggest creating a new profile for the user. That should get rid of the problem. Whatever it is. John "iains" wrote in message ... Further to setting both machines to 1024 x 768, I have now logged in on the other machine, and I can see the sheets with no issue. Would this suggest that there is something in his settings. Kind regards Iain "jaf" wrote: Hi Iain, The only other thing I would suggest is changing the monitor resolution on both machines to 1024 x 768 and see if they both look the same. It may be video driver related. John "iains" wrote in message ... Hi John There are no macros in the spreadsheet. Iain "jaf" wrote: Hi Iain, Are there any macros in these workbooks? John "iains" wrote in message ... Hi John Thanks for the suggestion I've checked both monitors, and they are both 96dpi. Some newer spreadsheets, created since 08 July 2009, are showing ok, but everything before that date is an issue on that particular machine. Kind regards Iain "jaf" wrote: Hi Iain, Sounds like the windows font sizes (dpi) are different. In XP goto control panel display properties, the general tab. Check the DPI setting in the top drop down box. 96 dpi is normal. John "iains" wrote in message ... On a series of spreadsheets I can see from A1 to N29 (14 Columns) on 100% view (XP), however one of my users can see from A1 to EE29 (109 Columns) (so it is very condensed), also on 100% view (2003). The print preview is also mis-aligned. This is only an issue on about 20 spreadsheets, of similar layout, others are fine. If the user views the problem series on other machines then they are fine. There is nothing obvious in preferences, and the other workbooks are ok. My screen is 15 at 1280 x 960; the user has a 17 at 1290 x 1024. I appreciate that you would see more on a larger screen, but not to the point that the screen can not be worked with. The user with the issue is seeing 109 columns, whereas I see 14. I would not expect that much difference to the working screen. Ive changed the monitor twice, once to an identical 17 monitor, and once to another 17 model. Each time the spreadsheet view is compressed. The spreadsheets in question were working fine up until 30 June, when the used went on holiday, an on their return on 08 July the view was causing problems. No other issues with this user account or system. Kind regards Iain Stedman |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2000 patch to view newer Excel versions (2003 and 2007) | Excel Discussion (Misc queries) | |||
What is the best way of managing Excel spreadsheet versions? | Excel Discussion (Misc queries) | |||
How compatible is Excel 2003 with previous versions | Excel Discussion (Misc queries) | |||
Office Excel 2003 Versions and VBA | Setting up and Configuration of Excel | |||
Do any newer versions of Excel (2003 or XP) offer more than 65,53. | Excel Worksheet Functions |