Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 254
  • Last Modified:

I am allowed to view part of my spreadsheet

I have spreadsheet made up of data for January, February and March.  I am allowed to looked at March only.  There are no frozen panes.  I have gone through the entire view commands and nothing changes. I have played around with F1 and all of the function keys and nothing. This spreadsheet is shared between four computers using dropbox.com.
0
wwfashion
Asked:
wwfashion
  • 4
  • 2
1 Solution
 
JohnBusiness Consultant (Owner)Commented:
Without seeing the spreadsheet it is hard to tell.

1. Have people used Group (under Data) to group ranges of cells. There would be a + sign to expose these.

2. Have people pulled a column completely closed. You can determine this if columns appear to be missing.

3. Under View, there is Split as well as Freeze, but you appear to have looked at these.

.... Thinkpads_User
0
 
wwfashionAuthor Commented:
I checked both of your possible solutions and neither of them were the problem.  Thanks so your quick response.
0
 
JohnBusiness Consultant (Owner)Commented:
Can anyone else see the entire sheet?  Is the sheet maximized in your Excel Window?  

... Thinkpads_User
0
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

 
wwfashionAuthor Commented:
No one else can see the entire sheet.  I have tried full screen and all it does is show March only.
0
 
JohnBusiness Consultant (Owner)Commented:
No one else can see the entire sheet.

So something has corrupted the sheet.  

Try this:

1. Open the Workbook.

2, Open a new Workbook (blank).

3. Go to the first workbook and the problem sheet.  Select All and copy.

4. Go to the new Workbook and Paste.

Does the new Workbook/Sheet work?  

If not, you will probably have to rebuild the worksheet.

.... Thinkpads_User
0
 
Shanan212Commented:
1. Is it, hidden? Do you know how to check for these?
1.1 It could be hidden using VBA (in which case, it has to be unlocked from VBA Editor)
2. Can you see the tabs for other months? If you cant see the tabs, then the tabs can be disabled.

Let me know the answer for 1 and 2.
0
 
JohnBusiness Consultant (Owner)Commented:
@wwfashion - Thanks and I was happy to help.

.... Thinkpads_User
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now