Excel problems

Hazzanet

Okay, the Mac Help on MS says:

libra10

Thanks once again Hazzanet.

Have had a look at the settings, and each option regarding scroll bars are already ticked. I tried un-ticking but didn't seem to change anything.

Checked another Spreadsheet I have, (which also includes a number of separate pages), and the settings within the problem worksheet are exactly the same as the worksheet which is fine.

I looked at File, Properties, (of problem worksheet), and it shows that there are worksheets ranging from 2006 to 2013. It looks like they are there somewhere, it's just finding them again.

It really is a mystery isn't it?

I really appreciate all the help you've given, I really appreciate all the trouble you have taken.

WTFH

Are the other sheets hidden/protected? (is it your spreadsheet, or one someone has sent you?)

Mattjimf

This may be what you need - http://office.microsoft.com/en-gb/mac-excel-help/show-or-hide-sheets-HA102928020.aspx

libra10

The worksheets are my own and not shared, and they shouldn't be hidden or protected.

I think where I messed up is when transferring from Office 2007 (on PC) to Office 2011 (on Mac). Along with data I wanted, some of the data seemed to be unreadable, which I think was a problem transferring from one system to another.

Unfortunately I deleted what I thought to be 'gibberish', saving the valid data without checking that other features of this spreadsheet were correct.

Have checked the settings above (so kindly provided), but nothing seems to change the problems.

It looks like I'm going to have to go back to data saved on my PC and using my USB stick, transfer again. Unfortunately this data is several months out of date, will have to try and catch up a little.

I really value all the help provided, and can't thank MSE users enough.

Thanks once again.

WTFH

A quick check...
Have you used colours on the tabs?
I know some people love doing this and it can cause problems between 2007 and 2010 on a PC. Might be similar going from PC to Mac.

I'll fire up my mac later and see if I can replicate it.

libra10

Thanks WTFH, no have never used colours, prefer to keep as simple as possible.

In all my years using spreadsheets have never come across this problem before. Another spreadsheet I transferred is fine, I think it's when I deleted some data which didn't seem to make sense where the problem occurred.

Thank you

Jivesinger

Could it be that spreadsheet is not maximised in the window and you can't see the tabs because they are "off the bottom of the screen".

Is there an option called something like View | Arrange All?

WTFH

If you have the new data still on the mac and it only relates to this year, then save that file with a new name, copy the original file over from the PC and just update the 2013 tab with the data from your mac - you might not have that much rework to do.

(Oh, and I'm glad to hear you don't put colours on tabs - it's one of my pet hates, along with leaving row 1 blank, or writing headers in 3 rows, or leaving the first column blank so it "looks better")

Nick_C

This works on a PC, don't know about Macs.

If there is more than one sheet, but the tabs are not displayed, you can move between the sheets by pressing (<CTRL> + <PGUP>) or (<CTRL> + <PGDN>)

If the tabs are hidden, unhide then by selecting the following menu options:- File - Options - Advanced. Scroll down to the section marked "Display options for this Workbook". "Show Sheet Tabs" should be checked (on).

If sheets are hidden, you can unhide them by holding down the <Alt> key and pressing O H U (Format Sheet Unhide)