A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

PASTE DOESNT WORK



 
 
Thread Tools Display Modes
  #1  
Old April 17th, 2009, 06:10 PM posted to microsoft.public.excel.worksheet.functions
robin l
external usenet poster
 
Posts: 7
Default PASTE DOESNT WORK

Can I send someone my spreadsheet - pasting from one spreadsheet to another
is not working. Dates and other data do not paste correctly and all my
data gets corrupted.

Thanks,

Robin
  #2  
Old April 17th, 2009, 07:38 PM posted to microsoft.public.excel.worksheet.functions
Glenn[_6_]
external usenet poster
 
Posts: 1,245
Default PASTE DOESNT WORK

robin l wrote:
Can I send someone my spreadsheet - pasting from one spreadsheet to another
is not working. Dates and other data do not paste correctly and all my
data gets corrupted.

Thanks,

Robin



Describe in some detail "not working" and "data gets corrupted".
  #3  
Old April 17th, 2009, 08:04 PM posted to microsoft.public.excel.worksheet.functions
Sheeloo
external usenet poster
 
Posts: 797
Default PASTE DOESNT WORK

Make sure that both spreadsheets are opened in the same instance...
To test
Copy something
go to the other workbook
right click and choose Paste Special... do you see all options (means same
instance) like Values, Formats etc. or only limited ones (means separate
instances) like paste as text,...?

Try this
Open the first workbook
Open the second using the File-Open command from within Excel

Try pasting... it should work

To open all workbooks in same instance try this;
Close Excel first and On the Windows Taskbar

1) Start-Run- excel.exe /unregserver -OK.
2) Start-Run- excel.exe /regserver -OK.

See the space between exe and /regserver

You might have to designate a full path to excel.exe (most likely C:\Program
Files\Microsoft Office\Office11)

In that case Start-Run- "C:\Program Files\Microsoft
Office\Office11\excel.exe" /regserver - OK

Note: 1. quotes are required because of spaces in the path
2. Office11 means Excel 2003. Excel 2007 is Office12

"robin l" wrote:

Can I send someone my spreadsheet - pasting from one spreadsheet to another
is not working. Dates and other data do not paste correctly and all my
data gets corrupted.

Thanks,

Robin

  #4  
Old April 17th, 2009, 08:18 PM posted to microsoft.public.excel.worksheet.functions
robin l
external usenet poster
 
Posts: 7
Default PASTE DOESNT WORK

Well, I copy dates and other data from one spreadsheet into another
spreadsheet and different dates and data are pasted that have nothing to do
with anything. I.e I copy 10/1/08 and 4/2/03 pastes.

Protection is off.

"Glenn" wrote:

robin l wrote:
Can I send someone my spreadsheet - pasting from one spreadsheet to another
is not working. Dates and other data do not paste correctly and all my
data gets corrupted.

Thanks,

Robin



Describe in some detail "not working" and "data gets corrupted".

  #5  
Old April 17th, 2009, 09:26 PM posted to microsoft.public.excel.worksheet.functions
Ken Wright
external usenet poster
 
Posts: 199
Default PASTE DOESNT WORK

Don't worry, you're not going insane. In your workbook that has the 08
date, go to Tools / Options / Calculation and untick the "1904 Date System"
option, which is likely to be the cause.

See here in the section "The Two Date Systems Of Excel" for more info.
http://cpearson.com/excel/datetime.htm

Regards
Ken.......................


"robin l" wrote in message
news
Well, I copy dates and other data from one spreadsheet into another
spreadsheet and different dates and data are pasted that have nothing to
do
with anything. I.e I copy 10/1/08 and 4/2/03 pastes.

Protection is off.

"Glenn" wrote:

robin l wrote:
Can I send someone my spreadsheet - pasting from one spreadsheet to
another
is not working. Dates and other data do not paste correctly and all
my
data gets corrupted.

Thanks,

Robin



Describe in some detail "not working" and "data gets corrupted".



  #6  
Old April 17th, 2009, 09:46 PM posted to microsoft.public.excel.worksheet.functions
Ken Wright
external usenet poster
 
Posts: 199
Default PASTE DOESNT WORK

Must admit i had assumed that the OP simply threw in what they believed to
be a couple of representative dates as opposed to actual values.

Regards
Ken..................



"Glenn" wrote in message
...
I though about that, but 10/1/08 doesn't convert to 4/2/03 for me when I go
between date systems...

October 1, 2008 becomes September 30, 2004
January 10, 2008 becomes January 9, 2004



Ken Wright wrote:
Don't worry, you're not going insane. In your workbook that has the 08
date, go to Tools / Options / Calculation and untick the "1904 Date
System" option, which is likely to be the cause.

See here in the section "The Two Date Systems Of Excel" for more info.
http://cpearson.com/excel/datetime.htm

Regards
Ken.......................


"robin l" wrote in message
news
Well, I copy dates and other data from one spreadsheet into another
spreadsheet and different dates and data are pasted that have nothing to
do
with anything. I.e I copy 10/1/08 and 4/2/03 pastes.

Protection is off.

"Glenn" wrote:

robin l wrote:
Can I send someone my spreadsheet - pasting from one spreadsheet to
another
is not working. Dates and other data do not paste correctly and all
my
data gets corrupted.

Thanks,

Robin

Describe in some detail "not working" and "data gets corrupted".



  #7  
Old April 17th, 2009, 10:36 PM posted to microsoft.public.excel.worksheet.functions
Glenn[_6_]
external usenet poster
 
Posts: 1,245
Default PASTE DOESNT WORK

robin l wrote:
Can I send someone my spreadsheet - pasting from one spreadsheet to another
is not working. Dates and other data do not paste correctly and all my
data gets corrupted.

Thanks,

Robin


"Glenn" wrote:

Describe in some detail "not working" and "data gets corrupted".


robin l wrote:
Well, I copy dates and other data from one spreadsheet into another
spreadsheet and different dates and data are pasted that have nothing to do
with anything. I.e I copy 10/1/08 and 4/2/03 pastes.

Protection is off.



Possibly dumb question, but exactly how are you copying and pasting?


Format the cell containing 10/1/08 as a number instead of a date (easiest way is
to click on the comma on the Formatting toolbar). Does it display "39,722.00"
now? Or "39,457.00" (I don't know if you are using m/d/y or d/m/y)?

If either number above is correct, copy it and paste it into the other
worksheet. What does that display? If it is the same as in the original
worksheet, then format it as a date. Now what does it display?
  #8  
Old April 17th, 2009, 10:39 PM posted to microsoft.public.excel.worksheet.functions
Glenn[_6_]
external usenet poster
 
Posts: 1,245
Default PASTE DOESNT WORK

I though about that, but 10/1/08 doesn't convert to 4/2/03 for me when I go
between date systems...

October 1, 2008 becomes September 30, 2004
January 10, 2008 becomes January 9, 2004



Ken Wright wrote:
Don't worry, you're not going insane. In your workbook that has the 08
date, go to Tools / Options / Calculation and untick the "1904 Date System"
option, which is likely to be the cause.

See here in the section "The Two Date Systems Of Excel" for more info.
http://cpearson.com/excel/datetime.htm

Regards
Ken.......................


"robin l" wrote in message
news
Well, I copy dates and other data from one spreadsheet into another
spreadsheet and different dates and data are pasted that have nothing to
do
with anything. I.e I copy 10/1/08 and 4/2/03 pastes.

Protection is off.

"Glenn" wrote:

robin l wrote:
Can I send someone my spreadsheet - pasting from one spreadsheet to
another
is not working. Dates and other data do not paste correctly and all
my
data gets corrupted.

Thanks,

Robin

Describe in some detail "not working" and "data gets corrupted".



  #9  
Old April 18th, 2009, 03:08 PM posted to microsoft.public.excel.worksheet.functions
robin l
external usenet poster
 
Posts: 7
Default PASTE DOESNT WORK

You are onto something - but when the 2 spreadsheet have diff date
calculation (1904 vs not) , how can i get the info from the copy spreadsheet
to past correctly? When I change both to the same date calculation - all the
dates get corrupted even when I say past values only.

"Ken Wright" wrote:

Don't worry, you're not going insane. In your workbook that has the 08
date, go to Tools / Options / Calculation and untick the "1904 Date System"
option, which is likely to be the cause.

See here in the section "The Two Date Systems Of Excel" for more info.
http://cpearson.com/excel/datetime.htm

Regards
Ken.......................


"robin l" wrote in message
news
Well, I copy dates and other data from one spreadsheet into another
spreadsheet and different dates and data are pasted that have nothing to
do
with anything. I.e I copy 10/1/08 and 4/2/03 pastes.

Protection is off.

"Glenn" wrote:

robin l wrote:
Can I send someone my spreadsheet - pasting from one spreadsheet to
another
is not working. Dates and other data do not paste correctly and all
my
data gets corrupted.

Thanks,

Robin


Describe in some detail "not working" and "data gets corrupted".




  #10  
Old April 18th, 2009, 06:27 PM posted to microsoft.public.excel.worksheet.functions
Ken Wright
external usenet poster
 
Posts: 199
Default PASTE DOESNT WORK

So let me just clarify, with both files confirmed as NOT using the 1904 date
system, if you copy a date from one to the other, the data changes?

What is the data you are copying, ie is it a formula? What if you hard wire
a date into your first workbook and then copy and paste into the second,
what happens then?

Regards
Ken...................


"robin l" wrote in message
...
You are onto something - but when the 2 spreadsheet have diff date
calculation (1904 vs not) , how can i get the info from the copy
spreadsheet
to past correctly? When I change both to the same date calculation - all
the
dates get corrupted even when I say past values only.

"Ken Wright" wrote:

Don't worry, you're not going insane. In your workbook that has the 08
date, go to Tools / Options / Calculation and untick the "1904 Date
System"
option, which is likely to be the cause.

See here in the section "The Two Date Systems Of Excel" for more info.
http://cpearson.com/excel/datetime.htm

Regards
Ken.......................


"robin l" wrote in message
news
Well, I copy dates and other data from one spreadsheet into another
spreadsheet and different dates and data are pasted that have nothing
to
do
with anything. I.e I copy 10/1/08 and 4/2/03 pastes.

Protection is off.

"Glenn" wrote:

robin l wrote:
Can I send someone my spreadsheet - pasting from one spreadsheet to
another
is not working. Dates and other data do not paste correctly and
all
my
data gets corrupted.

Thanks,

Robin


Describe in some detail "not working" and "data gets corrupted".






 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 07:35 PM.


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