MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Pivot Table Creates Ghost


Posted by Jayn on December 05, 2001 8:31 AM

I have created my first pivot table in Excel and it seems to work perfectly. The only problem is that when I open the workbook onto the tab where I am entering the data there is a "ghost" cell highlighted -- whatever cell I left my cursor on in the pivot table. As soon as I start typing it goes away. It's a minor annoyance, but I wonder if I did something wrong or if this is typical. I am using Excel 2000. Thanks, Jayn


Posted by Mark W. on December 05, 2001 10:59 AM

You must have the Halloween edition... Just kidding...

I'm wondering if your Workbook is so large that
Excel is laboring with screen refreshes. You
could try unchecking the "Save data with table
layout" option and see if this decreases the
size of your workbook and eliminates the problem.

Posted by Jayn on December 05, 2001 12:09 PM

Re: You must have the Halloween edition... Just kidding...

Yeah, that would be my luck to get the spooky version! I unchecked that box and my workbook is MUCH smaller. But I still have the shadow from the pivot table in my data sheet. If you're curious I could email it to you.

Posted by Mark W. on December 05, 2001 2:10 PM

Re: You must have the Halloween edition... Just kidding...

Perhaps your PivotTable somehow corrupted your
Worksheet -- and hopefully, not your entire Workbook.
Consider, deleting the Worksheet where your PivotTable
resides and the re-create it on a fresh Worksheet
(with the "Save data with table layout" option
not checked). Beyond this I don't know what to
recommend.

Posted by Jayn on December 05, 2001 3:59 PM

Re: You must have the Halloween edition... Just kidding...

Hi Mark,
I figured out that I can make it go away if I uncheck the box "Refresh on open". When I have that box checked as soon as I open the workbook it updates the table and then I get the ghost cell highlighted on my datasheet wherever my cursor last was positioned in the pivot table.