Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-14-2011, 12:13 PM
tpcervelo tpcervelo is offline Delete option greyed out when trying to delete row 1 Windows XP Delete option greyed out when trying to delete row 1 Office 2003
Novice
Delete option greyed out when trying to delete row 1
 
Join Date: Sep 2010
Posts: 5
tpcervelo is on a distinguished road
Default Delete option greyed out when trying to delete row 1

I have a Excel 2007 workbook that has a SQL query returning 6 fields from a table. I need to delete Row 1 containing the field names so the workbook contains only data. When I right click on Row 1 the 'delete' option is greyed out. The workbook/row is not protected and I have removed the Auto-Filter function. I am able to delete any other row.
Any ideas?
Thanks for any help...
Reply With Quote
  #2  
Old 11-14-2011, 06:00 PM
mgonda mgonda is offline Delete option greyed out when trying to delete row 1 Windows XP Delete option greyed out when trying to delete row 1 Office 2007
Novice
 
Join Date: Nov 2011
Posts: 3
mgonda is on a distinguished road
Default

Do you have a data connection that is bringing in the sql query? If so that can limit the field manipulation capabilities.

Mark Gonda
Reply With Quote
  #3  
Old 11-15-2011, 06:48 AM
tpcervelo tpcervelo is offline Delete option greyed out when trying to delete row 1 Windows XP Delete option greyed out when trying to delete row 1 Office 2003
Novice
Delete option greyed out when trying to delete row 1
 
Join Date: Sep 2010
Posts: 5
tpcervelo is on a distinguished road
Default Delete option greyed out when trying to delete row 1

Solved...there is a check box on the Design tab that allows header row to be turned off.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Delete option greyed out when trying to delete row 1 Cannot delete folders klingenfelter Outlook 10 02-04-2011 01:35 PM
delete email message via blackberry and have it delete on my pop3 and my outlook Iamthestorm Outlook 2 10-28-2010 12:21 AM
Delete option greyed out when trying to delete row 1 Delete sheet through VBA Salim Khan Excel 1 08-30-2010 09:11 AM
Some emails will not delete Shawn76 Outlook 0 07-01-2010 01:33 PM
Delete option greyed out when trying to delete row 1 Needs option to delete foward only when deleting reoccurring Peter Grono Outlook 1 02-19-2006 04:22 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:06 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft