![]() |
|
#1
|
|||
|
|||
|
I've been entering data into a worksheet and the created a pivot table.
Now I can't enter further data beyond the rang of the pivot table. How can this be fixed?
|
|
#2
|
||||
|
||||
|
Quote:
Is the worksheet (partially) protected?
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
|
#3
|
|||
|
|||
|
The pivot table goes to row 123. below row 123 a grey area appears and I cannot ener data into row 124 because there is no row 124 and beyond. I did not invoke any protection.
|
|
#4
|
||||
|
||||
|
I don't remember how XP looks like but try selecting the entire sheet with Ctrl+A then Format - Column - Unhide
and Format - Rows - unhide That should help
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
|
#5
|
|||
|
|||
|
Thank you for your suggestion. The XP version is the same as 2003.
Your suggestion did not work. I had tried that. I however did come right by clicking on the down arrow of the primary column used for the pivot table and selecting all. I appreciate your efforts. Regards |
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Macro to unlock content controls | Catty | Word VBA | 7 | 03-18-2015 02:08 AM |
How to unlock .docx file (not password)
|
Mendopaul | Word | 1 | 09-14-2012 02:59 AM |
cross-referencing - lock/unlock updating
|
minszki | Word | 1 | 03-11-2012 11:28 AM |
| Unlock all types of attachments sent and received | balubeto | Outlook | 1 | 02-13-2012 11:32 PM |
How to unlock Drop-Down list
|
ilkks | Word | 4 | 05-06-2011 12:19 AM |