Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Somethings Missing . . . . .
All,
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? Doug |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Somethings Missing . . . . .
Don,
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. Doug |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Somethings Missing . . . . .
MsgBox s.Name -- Don Guillett SalesAid Software wrote in message oups.com... Don, 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. Doug |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Indicate missing number in a sequence (Part II) | Excel Discussion (Misc queries) | |||
Toolbars Missing, And option to Add Missing | Excel Discussion (Misc queries) | |||
INDIRECT.EXT problem with missing worksheets | Excel Worksheet Functions | |||
Inserting and Tracking Missing Sequence | Excel Discussion (Misc queries) | |||
interpolate missing data between points | Excel Worksheet Functions |