Excel 2010 Workbook not scrolling nor Pageup/PageDown

Topic

New Reply

I have created an XLSM workbook using Excel 2010 (32 bit) that has two Password Protected Worksheets. It works perfectly on my Windows 7 64 bit computer and my Windows 8.1 32 bit computer, both using Excel 2010 32 bit.

When I send this workbook to a friend (using Windows 8.1 32 bit and Excel 2010 32 bit) who saves it to “My Documents” the opens it, clicks Enable twice to defeat the Excel “protection” the primary Worksheet is displayed but it is not possible to navigate around it using the Arrow Keys, PageUp/PageDown keys or the Scroll Bars. The vertical scroll bar indicates the Row it should move to, but the display does not move. The Ribbon appears to be functioning normally.

I’ve been through the File>Option>Trust Centre Settings and they are all exactly the same as on my computer.

Anyone got any bright ideas as to what the cause of this frustrating problem could be?

Any and all assistance very much appreciated.

Cheers

BygAuldByrd

Reply | Quote

Replies

Make sure the scroll lock is off

Reply | Quote

Problem resolved;)

It was not the Scroll Lock key – thanks for pointing it out for me to check.

The problem was that the top 31 rows of the Sheet are frozen and on my friend’s computer, even at 75% zoom only the top 30 rows were being displayed. Testing with the Zoom at 50% and 25% proved the Workbook was working correctly:-)

Now I have to redesign the Sheet so that the data columns below the top 31 rows can be seen and are of a size that is workable.
Thanks

BygAuldByrd

Reply | Quote

BAB,

That must be some spreadsheet as my 23″ monitor only shows 31 rows with a blank worksheet! If I minimize the ribbon I get 35.5 rows so you may want to think about that as a way to get more rows on the screen. If I may ask why so many rows frozen? :cheers:

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs

Reply | Quote

It is quite a big spread sheet. It starts out at about 50 narrow columns wide and 45+ rows which increases forever as more data is added daily.

The top 30 or so (now reduced to 21) rows are taken up by 5 charts that reflect the market data entered into the columns below the charts. Only the charts and the most recent data is displayed as the charts are frozen in position, while the data columns scroll down as more data is entered. 31 rows on screen is not a problem for me as my laptop screen is 1600×1050 and comfortably shows 43 rows with 100% zoom, while my attached 23″ monitor is 1920×1200, which displays 52 rows at 100% zoom.
38439-20141118-Trend-Follower-Screenshot

I think my friend’s computer only has a vertical resolution of around 768 or 800, hence the issue. When I created the workbook I never considered sharing it with others until they saw it and figured they could use it without the hard yakka of creating it – and they don’t have the skill to so anyway. So, in the process I’ve learned a few mow Excel/VBA tricks.

Cheers

BygAuldByrd

Reply | Quote

BygAuldByrd,

Maybe something like this may be helpful. You can toggle the graphs to be displayed or to be hidden if you want access to the data below it. Toggling back and forth will not change the rows you have frozen; it will just hide them. In this example I have set the rows containg the graphs to a named reange called MarketData.

Code:

Public Sub ToggleData()
If [MarketData].EntireRow.Hidden = False Then
    [MarketData].EntireRow.Hidden = True
Else:
    [MarketData].EntireRow.Hidden = False
End If
End Sub

You can set the macro to short keys (ex. Ctrl-z) and hide or view the first 20 rows or how many your graphs encompass.

HTH,
Maud

Reply | Quote

Hi HTH,

Thanks for the suggestion. It is similar to one that I had tried and didn’t really meet my requirements. I’ve also tried, in the past, having the charts on a separate sheet and using a “Camera” shot of them on the data sheet, with a Button coded to be able to display the “Camera” shot or turn it off. That approach also was not appropriate for my present application.

For those not familiar with it, the “Camera” tool is a great way of making a re-sizable image of a chart (or group of charts) that always reflects the changing data in the underlying charts. This great tool is hidden away and not on the Ribbon (in Excel 2010 and prior versions, I haven’t used Excel 2013 so can’t comment on it). To find it customize the Ribbon. I’ve added it, along with a a number of other special tools I use to new Tab (called “My Favourite Tools”). It’s listed under “All Commands” in the”Customize Ribbon” dialogue.

38454-20141120-Excel-2010-Customisse-Ribbon-Camera-Tool

Cheers

Trevor

Reply | Quote

Trevor,

What are your requirements to be able to see more of the data? Maybe there is something out there that can do what you want to do.

Reply | Quote

Hi Maudibe,

As far as I’m concerned at this time I’ve resolved the issue as noted in my post of 18 Nov.

Thanks for your input. It is appreciated.

Cheers

Trevor

Reply | Quote

Hi Trevor

Glad you resolved the issue.
I presume you opted for the simplest solution of all, which is to tell your friend to get a 23″ monitor.

zeddy

Reply | Quote