LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old April 20th 06, 01:15 PM posted to microsoft.public.excel.misc
Posts: n/a
Default Somethings Missing . . . . .


I have an excel sheet which looks like it has 3 lines ( I thought they
were borders ) but I cant get rid of them.

When I try to select the two rows (one above the line and one below)
and delete them. The lines stay there.

Out of desperation I deleted everything on my spreadsheet, and now I
have a blank spreadsheet with three straight lines on it.

Here the odd part, when I try to add a row I now get an error message
telling me "your formulat contains an invalid external reference to a
wroksheet" So now I know that something is there, but I have no way of
finding out what.

A whil back I had this problem and it ended up being charts there we
too small for my mouse to select. Someone pointed me to little program
which went through and found litle stuff like htis.

Any ideas?


  #3   Report Post  
Old April 20th 06, 01:46 PM posted to microsoft.public.excel.misc
[email protected]
Posts: n/a
Default Somethings Missing . . . . .


Great. I will give this a run. What if there were shapes or charts I
wanted to keep? I sthere a way of finding out the names of the shapes
or charts and then manually selecting them, and making them viewable?

I know, I'm never happy with the just the answer I have to know more.

Thanks for the quick reply.


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Indicate missing number in a sequence (Part II) mmock Excel Discussion (Misc queries) 3 February 22nd 06 07:13 PM
Toolbars Missing, And option to Add Missing SmeetaG Excel Discussion (Misc queries) 3 October 19th 05 11:43 AM
INDIRECT.EXT problem with missing worksheets Barb Reinhardt Excel Worksheet Functions 7 October 19th 05 01:27 AM
Inserting and Tracking Missing Sequence matt Excel Discussion (Misc queries) 2 September 12th 05 04:26 AM
interpolate missing data between points Rocket Rod Excel Worksheet Functions 2 February 27th 05 07:24 PM

All times are GMT +1. The time now is 09:16 AM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Excel"


Copyright © 2017