Warning

 

Close

Confirm Action

Are you sure you wish to do this?

Confirm Cancel
PSA
Member Login

Posted: 6/21/2011 12:48:27 PM EDT
[Last Edit: 6/21/2011 12:48:57 PM EDT by Compass]
How can I delete these tables (Apps, DataOnly, Times2G, & Times3G)? When selected, the delete button is grayed out. All I can do is edit them.

Link Posted: 6/21/2011 12:50:02 PM EDT


Do it in Access maybe?

Link Posted: 6/21/2011 12:56:31 PM EDT
Originally Posted By Tomislav:
Do it in Access maybe?



I'm not seeing a way to do that.
Link Posted: 6/21/2011 1:15:58 PM EDT
Open the folder where they are and delete them? *shrug*
Link Posted: 6/21/2011 1:20:57 PM EDT
Originally Posted By MoparMike:
Open the folder where they are and delete them? *shrug*


There isn't a folder for them. They are saved within the worksheet that I am working on.
Link Posted: 6/21/2011 7:00:17 PM EDT
Is the sheet "protected"?
Link Posted: 6/21/2011 7:03:43 PM EDT
Select the named range and then delete the range name in the name box
Link Posted: 6/21/2011 7:08:51 PM EDT
I can't answer your specific problem, but in my life I've come across a few occasions where an excel workbook was so colossally fucked the only solution was to copy and paste everything into a completely new workbook.



Given what I see in the screenshot, that will probably be a lot of copy and pasting and probably won't help in your specific situation.



IOW:  I got nutthin.  Don't use excel as a database.  Use databases for databases.  Good luck.  
Link Posted: 6/21/2011 7:13:10 PM EDT



Originally
Posted By A_Free_Man:



Is the sheet "protected"?


Nope.






Originally
Posted By NoVaGator:



Select the named range and then delete the range name in the name box


Tried that, no dice.




Originally Posted By fiver:


I can't answer your specific problem, but in my life I've come across a few occasions where an excel workbook was so colossally fucked the only solution was to copy and paste everything into a completely new workbook.



Given what I see in the screenshot, that will probably be a lot of copy and pasting and probably won't help in your specific situation.



IOW:  I got nutthin.  Don't use excel as a database.  Use databases for databases.  Good luck.  


That's what I am thinking of doing. It's the boss' spreadsheet and he gave me free reign to revamp it, but I have to keep his basic format. There's probably 12 sheets or so in that book. All sheets are different, too.



It's not a database though. And he wouldn't let me use anything other than Excel anyways, so there's no point in trying.



 
Link Posted: 6/21/2011 7:17:55 PM EDT
Are they all innerconnected? Maybe try deleting data and then the sheet?
Link Posted: 6/21/2011 7:36:48 PM EDT



Originally Posted By Penguin_101:


Are they all innerconnected? Maybe try deleting data and then the sheet?


That's just it. I can't find what's connecting them.





The spreadsheet is screwed up. I just need to start it from scratch. Boss has a tendency to make changes and forget he made them, and come back to it a few months later and do it all over again....making things sticky.



 
Link Posted: 6/21/2011 7:40:44 PM EDT
You can't delete tables in Excel.  If you go to the sheet with the table and right click, go to the menu titled Table.  Click convert to range and it will disappear from the name manager.
Link Posted: 6/21/2011 7:48:02 PM EDT



Originally Posted By exponentialpi:


You can't delete tables in Excel.  If you go to the sheet with the table and right click, go to the menu titled Table.  Click convert to range and it will disappear from the name manager.


I will try this.



 
Link Posted: 6/23/2011 7:33:49 AM EDT
Originally Posted By Compass:

Originally Posted By exponentialpi:
You can't delete tables in Excel.  If you go to the sheet with the table and right click, go to the menu titled Table.  Click convert to range and it will disappear from the name manager.

I will try this.
 


That worked!!! Thank you so much!!
Top Top