INSERT CELLS option missing

[Neily]

I had a spreadsheet which uses formulas to format the data correctly on another sheet from one sheet.

The data that is required to be formated and calculated upon, is taken from a program that produces a report that outputs to an excel file.

The relevant cells are then copied to my spreadsheet by selecting the range of cells required and then going to my spreadsheet, right-clicking and selecting 'Insert Cells'

This however, doesn't work when I open this up on another machine. The option is there to paste into a new workbook, but not in the one that I require. It works fine on another machine, just not this one.

Is there a reason why this option is missing?

THANKS

 

[DPlank]

Is this a manual process, or have you automated it in some way?

'Cos you can Insert Cells from the Insert menu as well, not just from the context menu.

Cheers,
Dave

"Yes, I'll stop finding bugs in the software - as soon as you stop writing bugs into the software." <-- Me

For all your testing needs: Forum1393

 

[GlennUK]

Are the workbooks in the same Excel session? Or are switching between different instances of Excel?

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[xlbo]

or is the workbook either read only or protected....?

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[Neily]

I shall check these and post back my findings!

THANKS

 

[Neily]

None of your suggestions were actually true.

THANKS

 

[infinitelo]

check in excel on both machines under tools-options edit tab

you may find paste options are differnt.



if it is to be it's up to me