Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,101
Default Excel 2000 to Excel 2003

Hi:
A friend is sending me a spreadsheet with formulas and macros created in
Excel running on Windows 2000. I am running Windows XP with Excel 2003.
Whenever I try to open his file, I am get two pop ups asking whether or not
to disable macros. Regardles of how I answer, the spreadsheet eventually
opens, but EXCEL says that the file was corrup and that it had to repair the
file. The repaired file is non-functional because all the macros have been
scripted. If I send the file back to the originator, he says it works fine.

The file was sent to another person with Windows XP and EXCEL 2003 and he
has the same problem. I tried the file at home with Windows XP and EXCEL and
again the same problem.

Any ideas on how to fix this problem?
Thanks

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Excel 2000 to Excel 2003

I'd ask the originator send the original file once more.

If that didn't work, I'd ask that the file be zipped and then sent.

Mike wrote:

Hi:
A friend is sending me a spreadsheet with formulas and macros created in
Excel running on Windows 2000. I am running Windows XP with Excel 2003.
Whenever I try to open his file, I am get two pop ups asking whether or not
to disable macros. Regardles of how I answer, the spreadsheet eventually
opens, but EXCEL says that the file was corrup and that it had to repair the
file. The repaired file is non-functional because all the macros have been
scripted. If I send the file back to the originator, he says it works fine.

The file was sent to another person with Windows XP and EXCEL 2003 and he
has the same problem. I tried the file at home with Windows XP and EXCEL and
again the same problem.

Any ideas on how to fix this problem?
Thanks


--

Dave Peterson
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,101
Default Excel 2000 to Excel 2003

Hi Dave:
That didn't help we have zipped, CD, etc. The problem still persist. Any
ideas on what could be the problem. Also, I made a mistake in the name. The
problem is between EXCEL 97 on a Window 2000 machine and EXCEL 2003 on a XP
machine.
Thanks


"Dave Peterson" wrote:

I'd ask the originator send the original file once more.

If that didn't work, I'd ask that the file be zipped and then sent.

Mike wrote:

Hi:
A friend is sending me a spreadsheet with formulas and macros created in
Excel running on Windows 2000. I am running Windows XP with Excel 2003.
Whenever I try to open his file, I am get two pop ups asking whether or not
to disable macros. Regardles of how I answer, the spreadsheet eventually
opens, but EXCEL says that the file was corrup and that it had to repair the
file. The repaired file is non-functional because all the macros have been
scripted. If I send the file back to the originator, he says it works fine.

The file was sent to another person with Windows XP and EXCEL 2003 and he
has the same problem. I tried the file at home with Windows XP and EXCEL and
again the same problem.

Any ideas on how to fix this problem?
Thanks


--

Dave Peterson
.

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Excel 2000 to Excel 2003

Your copy of xl2003 should be able to open a file created with xl97 with no
problems.

My next guess is that the file is corrupted some how. But the only fix I know
for that is to recreate the workbook. And that's could be a big job.

Mike wrote:

Hi Dave:
That didn't help we have zipped, CD, etc. The problem still persist. Any
ideas on what could be the problem. Also, I made a mistake in the name. The
problem is between EXCEL 97 on a Window 2000 machine and EXCEL 2003 on a XP
machine.
Thanks

"Dave Peterson" wrote:

I'd ask the originator send the original file once more.

If that didn't work, I'd ask that the file be zipped and then sent.

Mike wrote:

Hi:
A friend is sending me a spreadsheet with formulas and macros created in
Excel running on Windows 2000. I am running Windows XP with Excel 2003.
Whenever I try to open his file, I am get two pop ups asking whether or not
to disable macros. Regardles of how I answer, the spreadsheet eventually
opens, but EXCEL says that the file was corrup and that it had to repair the
file. The repaired file is non-functional because all the macros have been
scripted. If I send the file back to the originator, he says it works fine.

The file was sent to another person with Windows XP and EXCEL 2003 and he
has the same problem. I tried the file at home with Windows XP and EXCEL and
again the same problem.

Any ideas on how to fix this problem?
Thanks


--

Dave Peterson
.


--

Dave Peterson
  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,101
Default Excel 2000 to Excel 2003

Hi:
Yes, corruption seems to be the reason. My guess now is that the
orginator's computer system has some kind of low level conversion taking
place. Ie Linux to Intel, etc. Are you aware of any issues involving the
setup of each operating system to communicate with each other, ie. bitwise
swapping, etc.?

"Dave Peterson" wrote:

Your copy of xl2003 should be able to open a file created with xl97 with no
problems.

My next guess is that the file is corrupted some how. But the only fix I know
for that is to recreate the workbook. And that's could be a big job.

Mike wrote:

Hi Dave:
That didn't help we have zipped, CD, etc. The problem still persist. Any
ideas on what could be the problem. Also, I made a mistake in the name. The
problem is between EXCEL 97 on a Window 2000 machine and EXCEL 2003 on a XP
machine.
Thanks

"Dave Peterson" wrote:

I'd ask the originator send the original file once more.

If that didn't work, I'd ask that the file be zipped and then sent.

Mike wrote:

Hi:
A friend is sending me a spreadsheet with formulas and macros created in
Excel running on Windows 2000. I am running Windows XP with Excel 2003.
Whenever I try to open his file, I am get two pop ups asking whether or not
to disable macros. Regardles of how I answer, the spreadsheet eventually
opens, but EXCEL says that the file was corrup and that it had to repair the
file. The repaired file is non-functional because all the macros have been
scripted. If I send the file back to the originator, he says it works fine.

The file was sent to another person with Windows XP and EXCEL 2003 and he
has the same problem. I tried the file at home with Windows XP and EXCEL and
again the same problem.

Any ideas on how to fix this problem?
Thanks

--

Dave Peterson
.


--

Dave Peterson
.



  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Excel 2000 to Excel 2003

I don't know anything about that kind of stuff.

But both of you have to be running some kind of version of Windows, right?

Maybe you could ask him to create another workbook (just a test workbook) and
send it to you.

See if that works.

Mike wrote:

Hi:
Yes, corruption seems to be the reason. My guess now is that the
orginator's computer system has some kind of low level conversion taking
place. Ie Linux to Intel, etc. Are you aware of any issues involving the
setup of each operating system to communicate with each other, ie. bitwise
swapping, etc.?

"Dave Peterson" wrote:

Your copy of xl2003 should be able to open a file created with xl97 with no
problems.

My next guess is that the file is corrupted some how. But the only fix I know
for that is to recreate the workbook. And that's could be a big job.

Mike wrote:

Hi Dave:
That didn't help we have zipped, CD, etc. The problem still persist. Any
ideas on what could be the problem. Also, I made a mistake in the name. The
problem is between EXCEL 97 on a Window 2000 machine and EXCEL 2003 on a XP
machine.
Thanks

"Dave Peterson" wrote:

I'd ask the originator send the original file once more.

If that didn't work, I'd ask that the file be zipped and then sent.

Mike wrote:

Hi:
A friend is sending me a spreadsheet with formulas and macros created in
Excel running on Windows 2000. I am running Windows XP with Excel 2003.
Whenever I try to open his file, I am get two pop ups asking whether or not
to disable macros. Regardles of how I answer, the spreadsheet eventually
opens, but EXCEL says that the file was corrup and that it had to repair the
file. The repaired file is non-functional because all the macros have been
scripted. If I send the file back to the originator, he says it works fine.

The file was sent to another person with Windows XP and EXCEL 2003 and he
has the same problem. I tried the file at home with Windows XP and EXCEL and
again the same problem.

Any ideas on how to fix this problem?
Thanks

--

Dave Peterson
.


--

Dave Peterson
.


--

Dave Peterson
  #7   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,101
Default Excel 2000 to Excel 2003

Thanks, will give that a try, but I think they are writing it off as
something they can't do, at least with this workbook.

"Dave Peterson" wrote:

I don't know anything about that kind of stuff.

But both of you have to be running some kind of version of Windows, right?

Maybe you could ask him to create another workbook (just a test workbook) and
send it to you.

See if that works.

Mike wrote:

Hi:
Yes, corruption seems to be the reason. My guess now is that the
orginator's computer system has some kind of low level conversion taking
place. Ie Linux to Intel, etc. Are you aware of any issues involving the
setup of each operating system to communicate with each other, ie. bitwise
swapping, etc.?

"Dave Peterson" wrote:

Your copy of xl2003 should be able to open a file created with xl97 with no
problems.

My next guess is that the file is corrupted some how. But the only fix I know
for that is to recreate the workbook. And that's could be a big job.

Mike wrote:

Hi Dave:
That didn't help we have zipped, CD, etc. The problem still persist. Any
ideas on what could be the problem. Also, I made a mistake in the name. The
problem is between EXCEL 97 on a Window 2000 machine and EXCEL 2003 on a XP
machine.
Thanks

"Dave Peterson" wrote:

I'd ask the originator send the original file once more.

If that didn't work, I'd ask that the file be zipped and then sent.

Mike wrote:

Hi:
A friend is sending me a spreadsheet with formulas and macros created in
Excel running on Windows 2000. I am running Windows XP with Excel 2003.
Whenever I try to open his file, I am get two pop ups asking whether or not
to disable macros. Regardles of how I answer, the spreadsheet eventually
opens, but EXCEL says that the file was corrup and that it had to repair the
file. The repaired file is non-functional because all the macros have been
scripted. If I send the file back to the originator, he says it works fine.

The file was sent to another person with Windows XP and EXCEL 2003 and he
has the same problem. I tried the file at home with Windows XP and EXCEL and
again the same problem.

Any ideas on how to fix this problem?
Thanks

--

Dave Peterson
.


--

Dave Peterson
.


--

Dave Peterson
.

Reply
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
Strange 'protected cell' error affecting Excel 2003 but not Excel 2000? Pheasant Plucker® Excel Discussion (Misc queries) 1 April 10th 07 01:04 PM
Opening files in Excel 2003 saved in Excel 2000 without data loss... [email protected] Excel Discussion (Misc queries) 0 January 29th 07 07:19 PM
Upgrade from Excel 2000 to Excel 2003 without MS Office 2003? brigida3 Excel Discussion (Misc queries) 1 January 22nd 06 05:13 PM
User-defined functions created in Excel 2000 fail in Excel 2003 goodguy Excel Discussion (Misc queries) 1 October 3rd 05 07:04 PM
Excel 2003 crashes loading excel files created Excel 2000 Jeff Lewin Australia Excel Discussion (Misc queries) 0 June 27th 05 04:20 AM


All times are GMT +1. The time now is 05:44 PM.

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"