User Panel
User Panel
User Panel
|
Posted: 6/21/2011 12:48:27 PM EDT
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.
|
|
|
|
Posted: 6/21/2011 12:50:02 PM EDT
[#1]
Do it in Access maybe? |
|
|
|
Posted: 6/21/2011 12:56:31 PM EDT
[#2]
Quoted:
Do it in Access maybe?
I'm not seeing a way to do that. 
|
|
|
|
Posted: 6/21/2011 1:15:58 PM EDT
[#3]
Open the folder where they are and delete them? *shrug*
|
|
|
|
Posted: 6/21/2011 1:20:57 PM EDT
[#4]
Quoted:
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. |
|
|
|
Posted: 6/21/2011 7:00:17 PM EDT
[#5]
Is the sheet "protected"?
|
|
|
|
Posted: 6/21/2011 7:03:43 PM EDT
[#6]
Select the named range and then delete the range name in the name box
|
|
|
|
Posted: 6/21/2011 7:08:51 PM EDT
[#7]
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. |
|
|
|
Posted: 6/21/2011 7:13:10 PM EDT
[#8]
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. Quoted: 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. |
|
|
|
Posted: 6/21/2011 7:17:55 PM EDT
[#9]
Are they all innerconnected? Maybe try deleting data and then the sheet?
|
|
|
|
Posted: 6/21/2011 7:36:48 PM EDT
[#10]
Quoted: 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. |
|
|
|
Posted: 6/21/2011 7:40:44 PM EDT
[#11]
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.
|
|
|
|
Posted: 6/21/2011 7:48:02 PM EDT
[#12]
Quoted: 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.  |
|
|
|
Posted: 6/23/2011 7:33:49 AM EDT
[#13]
Quoted:
Quoted:
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!! |
|
|
Win a FREE Membership!
Sign up for the ARFCOM weekly newsletter and be entered to win a free ARFCOM membership. One new winner* is announced every week!
You will receive an email every Friday morning featuring the latest chatter from the hottest topics, breaking news surrounding legislation, as well as exclusive deals only available to ARFCOM email subscribers.
AR15.COM is the world's largest firearm community and is a gathering place for firearm enthusiasts of all types.
From hunters and military members, to competition shooters and general firearm enthusiasts, we welcome anyone who values and respects the way of the firearm.
Subscribe to our monthly Newsletter to receive firearm news, product discounts from your favorite Industry Partners, and more.
Copyright © 1996-2024 AR15.COM LLC. All Rights Reserved.
Any use of this content without express written consent is prohibited.
AR15.Com reserves the right to overwrite or replace any affiliate, commercial, or monetizable links, posted by users, with our own.
