Viewing Charts

[Al]

I have used Excel 2003 for a while and have developed a seven "sheet" for
following mutual funds and stocks. The first sheet is the spreadsheet itself
and the other pages are various charts (line, or area - nothing fancy).
Upon migrating to Office 2007 the transition on my desktop was smooth and
uneventful. I can see all sheets of the file. Not so on the laptop. Only
the spreadsheet sheet displays. NONE of the other pages show up. I even
added RAM so that there is now 1.256 Gig - same problem.

Suggestions?

 

[JLatham]

Have you checked to see if somehow those sheets have become hidden?
Right-click the tab on the normal sheet and see if [Unhide] is available and
if it is, click it to see a list of hidden sheets.

My first suggestion would be to run the Office Diagnostics in Excel on the
laptop:
Office Button (in upper right corner)
[Excel Options] button that is then shown in lower-right corner.
[Resources] group from the left pane and then [Diagnose] in right pane.

That may show an immediate, detected problem and let you repair. If it says
things are all fine and dandy, might try a repair installation of Office
anyhow on that system.

If none of that works, I'm thinking (just grabbing straws - nothing but thin
air to base this on) that perhaps the video card in the laptop is not up to
the job of displaying the graphics being output by the new Office (not just
Excel) graphics engine. Many people have noted that graphic/charting display
is problematic in 2007 - most of the complaints being a slowdown of the
response of Excel when there are charts to be displayed, recalculated, etc.

 

[Al]

Have you checked to see if somehow those sheets have become hidden?
Right-click the tab on the normal sheet and see if [Unhide] is available and
if it is, click it to see a list of hidden sheets.

My first suggestion would be to run the Office Diagnostics in Excel on the
laptop:
Office Button (in upper right corner)
[Excel Options] button that is then shown in lower-right corner.
[Resources] group from the left pane and then [Diagnose] in right pane.

That may show an immediate, detected problem and let you repair. If it says
things are all fine and dandy, might try a repair installation of Office
anyhow on that system.

If none of that works, I'm thinking (just grabbing straws - nothing but thin
air to base this on) that perhaps the video card in the laptop is not up to
the job of displaying the graphics being output by the new Office (not just
Excel) graphics engine. Many people have noted that graphic/charting display
is problematic in 2007 - most of the complaints being a slowdown of the
response of Excel when there are charts to be displayed, recalculated, etc.

I have used Excel 2003 for a while and have developed a seven "sheet" for
following mutual funds and stocks. The first sheet is the spreadsheet itself
and the other pages are various charts (line, or area - nothing fancy).
Upon migrating to Office 2007 the transition on my desktop was smooth and
uneventful. I can see all sheets of the file. Not so on the laptop. Only
the spreadsheet sheet displays. NONE of the other pages show up. I even
added RAM so that there is now 1.256 Gig - same problem.

Suggestions?

Actually, I found the answer (and it is really rather simple). I had a bad
printer driver selected with my default printer. It was a simple matter to
just select ANY printer that is up to date and, because Office apparently
uses the printer driver to render graphics, the problem was solved. Amazing,
huh?

 

[JLatham]

Yeah, that would have been about the last thing I would have guessed ... and
then only if someone else guessed it before it became my turn again <g>.

Good of you to put up the solution for future reference. Thanks for that.

Have you checked to see if somehow those sheets have become hidden?
Right-click the tab on the normal sheet and see if [Unhide] is available and
if it is, click it to see a list of hidden sheets.

My first suggestion would be to run the Office Diagnostics in Excel on the
laptop:
Office Button (in upper right corner)
[Excel Options] button that is then shown in lower-right corner.
[Resources] group from the left pane and then [Diagnose] in right pane.

That may show an immediate, detected problem and let you repair. If it says
things are all fine and dandy, might try a repair installation of Office
anyhow on that system.

If none of that works, I'm thinking (just grabbing straws - nothing but thin
air to base this on) that perhaps the video card in the laptop is not up to
the job of displaying the graphics being output by the new Office (not just
Excel) graphics engine. Many people have noted that graphic/charting display
is problematic in 2007 - most of the complaints being a slowdown of the
response of Excel when there are charts to be displayed, recalculated, etc.

I have used Excel 2003 for a while and have developed a seven "sheet" for
following mutual funds and stocks. The first sheet is the spreadsheet itself
and the other pages are various charts (line, or area - nothing fancy).
Upon migrating to Office 2007 the transition on my desktop was smooth and
uneventful. I can see all sheets of the file. Not so on the laptop. Only
the spreadsheet sheet displays. NONE of the other pages show up. I even
added RAM so that there is now 1.256 Gig - same problem.

Suggestions?

Actually, I found the answer (and it is really rather simple). I had a bad
printer driver selected with my default printer. It was a simple matter to
just select ANY printer that is up to date and, because Office apparently
uses the printer driver to render graphics, the problem was solved. Amazing,
huh?

 

[Al]

Yeah, that would have been about the last thing I would have guessed ... and
then only if someone else guessed it before it became my turn again <g>.

Good of you to put up the solution for future reference. Thanks for that.

You are welcome. The forum at Woody's Office Lounge (www.wopr.com) was
where the answer came from. A guy in the Netherlands pointed me in the right
direction.

Al