Excel 2007 Persistent Error: That command cannot be used on multiple selections

M

magoood

New Member
Joined
Jun 13, 2009
Messages
2
Hi
I'm using Excel 2007 and I want to do the following (I've uploaded a screen shot to better visualize what I was trying 2 do when getting the error message)
Screen Shot:
52z5k.jpg


What I'm trying to do is to copy the format of the very first table above and apply it on all the remaining 4 unformatted tables (using the Paste Special Command of copying formats) so what I did was:

1) Selecting the first table and then copying it
2) I pressed and hold the "CTRL" key to select the second, third and fourth table and now that stupid message showed up
3) I clicked on the OK of that message 2 make it go away and I continued selecting my remaining table
4) Now, when I click on the Paste button --->Paste Special, I get a "Paste Special" dialog box different from what I'm expecting

I wish if someone can help me with this issue

P.S. Office 2007 is fully updated with SP2

Thanks
 
Last edited:

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.
Sort by date Sort by votes
if I read correctly, you get the message while you are selecting the tables, and have not done anything else,

right click on the tab and view code. see if there is something being done when any of the cells you are selecting is selected.

also the different paste special screen. please attach a screen shot

I just realized I only have 2007 SP1, but the copy and multiple selection paste special format works on mine
 
Upvote 0
wsjackman said:
if I read correctly, you get the message while you are selecting the tables, and have not done anything else,

right click on the tab and view code. see if there is something being done when any of the cells you are selecting is selected.

also the different paste special screen. please attach a screen shot

I just realized I only have 2007 SP1, but the copy and multiple selection paste special format works on mine
Click to expand...
First, sorry 4 writing late - I just wanted 2 make sure of what I'm going 2 report right now:

For some unknown reasons, i wasn't able to reproduce the error message again after i posted the problem here on this forum. I don't know why but I tried so hard doing it so many times but the error went away and never came back. All what i have done is closing all the Excel files i have opened and restarted Excel again. Thank you for your time writing to me anyway
 
Upvote 0
I just started getting that same error with Excel 2007. I am only selecting one cell when I receive the error. Usually it's after I have already copied a different cell. I've tried ESC and closing and reopening. It is not confined to just one doc. Could still just be user error but i don't think so. Is this maybe a known error with Excel 2007? That would be hard to believe since i've been using it since, oh gee 2007 and on multiple computers. Any help would be appreciated.
 
Upvote 0
You must log in or register to reply here.

Similar threads

D
  • Question Question
Generating Reports in Word Using Data in Excel
Replies
1
Views
338
Dan_W
D
S
  • Question Question
HYPERLINK() function Seems Unable to Jump to Another Sheets Table and Filter
Replies
6
Views
225
Skyybot
Skyybot
W
  • Question Question
Macro/VBA code code for creating new excel file for each pivot table from a column filter
Replies
1
Views
442
Anthony47
A
J
  • Question Question
Using Sheets().Select in a Worksheet_Activate() macro
2
Replies
10
Views
446
jdun
J
D
  • Question Question
Cannot read google excel sheet
Replies
6
Views
421
DeepButi
D

Forum statistics

Threads
1,223,919
Messages
6,175,368
Members
452,638
Latest member
Oluwabukunmi

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top