LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Glibby Gibson
Posts: n/a
Default copy & paste formula between spreadsheets - not working

Normally if I copy and paste a cell or range of cells from one spreadsheet to
another, I get the cell(s) value to paste across; or if the source cell
contains a formula, I get the formula to paste across. I also get the option
to Paste Special and can chose values, formulas, formats, etc. etc.

I have one spreadsheet that will only copy a cell's value to the destination
spreadsheet (even if the source cell contains a formula). If I select paste
special, instead of the usual dialog box - formulas, values, formats, etc.
etc. - I get what looks like an object paste box with none of the options
that I want or expect. instead I see options for pasting a picture, bitmap,
XL object, XL 8.0 Format, etc. - whatever I chose I get an object or similar
pasted with the source cell value - no sign of the formulae.

I think there's a switch set in the source spreadsheet that is protecting
the cell data or making Excel think the entire spreadsheet is an object, or
whatever. I've made sure the cells are unlocked, the sheet is not protected
- what should I try next?

I've got 1800 rows of killer-complicated formulae and retyping them or
copying off the formula bar one at a time (yes that works!) is enough to
drive me to drink. Thanks.
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Can't Copy and Paste or Paste Special between Excel Workbooks wllee Excel Discussion (Misc queries) 5 April 29th 23 03:43 AM
How do I set up a copy and paste formula with ascending columns Ken Proj mgr New Users to Excel 4 February 27th 06 04:18 PM
Why won't Excel let me copy and paste my concantenate formula now Jennifer Excel Worksheet Functions 3 February 6th 06 05:14 PM
Macro to open workbook and copy and paste values in to orig workbo Dena X Excel Worksheet Functions 1 December 16th 05 12:13 AM
How can I copy and paste the text of a formula? Jeff Excel Worksheet Functions 1 August 30th 05 03:45 PM

All times are GMT +1. The time now is 04:47 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 ExcelBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Excel"