converting excel 2003 to 2007

[yogi]

This is working ok with the converter. The problem is that we have a large
(2mb) old excel file that will not convert. The conversion process just
seems to go on forever without ending. Any ideas?

 

[JoAnn Paules]

Can you still open the file with 2003?

 

[yogi]

JoAnn,
I can open the file but its just data...formatting gone, graphs gone

Can you still open the file with 2003?

--

JoAnn Paules
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"

This is working ok with the converter. The problem is that we have a
large
(2mb) old excel file that will not convert. The conversion process just
seems to go on forever without ending. Any ideas?

 

[JoAnn Paules]

Are you sure that file isn't corrupt? It sounds like it is.

--

JoAnn Paules
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"

JoAnn,
I can open the file but its just data...formatting gone, graphs gone

Can you still open the file with 2003?

--

JoAnn Paules
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"

This is working ok with the converter. The problem is that we have a
large
(2mb) old excel file that will not convert. The conversion process
just
seems to go on forever without ending. Any ideas?

 

[yogi]

i dont think so....it works on the old version...would it work on the old
version if it was corrupt? if it is corrupt how would i fix it? what else
could it be?
the reason that we think it is the file size is because we have another
document that is smaller in size and everything ports over fine.

Are you sure that file isn't corrupt? It sounds like it is.

--

JoAnn Paules
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"

JoAnn,
I can open the file but its just data...formatting gone, graphs gone

Can you still open the file with 2003?

--

JoAnn Paules
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"



This is working ok with the converter. The problem is that we have a
large
(2mb) old excel file that will not convert. The conversion process
just
seems to go on forever without ending. Any ideas?

 

[JoAnn Paules]

Is it a file you can share? I'd be willing to try and open it on my system
if you can.

--

JoAnn Paules
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"

i dont think so....it works on the old version...would it work on the old
version if it was corrupt? if it is corrupt how would i fix it? what
else
could it be?
the reason that we think it is the file size is because we have another
document that is smaller in size and everything ports over fine.

Are you sure that file isn't corrupt? It sounds like it is.

--

JoAnn Paules
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"

JoAnn,
I can open the file but its just data...formatting gone, graphs gone

:

Can you still open the file with 2003?

--

JoAnn Paules
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"



This is working ok with the converter. The problem is that we have
a
large
(2mb) old excel file that will not convert. The conversion process
just
seems to go on forever without ending. Any ideas?

 

[Harlan Grove]

This is working ok with the converter.  The problem is that we have a
large (2mb) old excel file that will not convert.  The conversion
process just seems to go on forever without ending. Any ideas?

2MB isn't a large Excel file. It's middle sized.

Anyway, what's in the file? Also, do you now have both the
original .XLS file and a [partially] converted .XLS[XMB] file? If so,
does the .XLS file still open correctly in Excel 2003? Does the .XLS
file open in Excel 2007? [Yes, Excel 2007 should be able to open .XLS
files.]

.XLS files have an annoying tendency to extend formatting too widely,
which is one of the reasons .XLS files tend to grow over time even
when there are no newly entered cells. It's possible this could be
your problem, and the conversion is taking forever because it's
extending nondefault formatting to row 65536 rather than applying it
to entire columns rather than to individual cells.

If you still have the original .XLS file, open it in Excel 2003 and
press [Ctrl]+[End] in each worksheet. Do you wind up in either column
IV or row 65536?

 

[yogi]

JoAnn,
Unfortunately the information is sensitive. We installed a plugin to solve
the issue Harlan brought up. But we got the same result. The file opens but
the formatting and graphs do not port over! It is strange that it worked for
one file that was smaller and not this particular file...

Yogi

Is it a file you can share? I'd be willing to try and open it on my system
if you can.

--

JoAnn Paules
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"

i dont think so....it works on the old version...would it work on the old
version if it was corrupt? if it is corrupt how would i fix it? what
else
could it be?
the reason that we think it is the file size is because we have another
document that is smaller in size and everything ports over fine.

Are you sure that file isn't corrupt? It sounds like it is.

--

JoAnn Paules
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"



JoAnn,
I can open the file but its just data...formatting gone, graphs gone

:

Can you still open the file with 2003?

--

JoAnn Paules
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"



This is working ok with the converter. The problem is that we have
a
large
(2mb) old excel file that will not convert. The conversion process
just
seems to go on forever without ending. Any ideas?

 

[yogi]

i thought i would also mention that as soon as i try to open the file, i get
the error "microsoft excel has encountered a problem and needs to close." if
you let it iterate then i eventually get the file open without the
formatting/graphs.

Is it a file you can share? I'd be willing to try and open it on my system
if you can.

--

JoAnn Paules
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"

i dont think so....it works on the old version...would it work on the old
version if it was corrupt? if it is corrupt how would i fix it? what
else
could it be?
the reason that we think it is the file size is because we have another
document that is smaller in size and everything ports over fine.

Are you sure that file isn't corrupt? It sounds like it is.

--

JoAnn Paules
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"



JoAnn,
I can open the file but its just data...formatting gone, graphs gone

:

Can you still open the file with 2003?

--

JoAnn Paules
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"



This is working ok with the converter. The problem is that we have
a
large
(2mb) old excel file that will not convert. The conversion process
just
seems to go on forever without ending. Any ideas?

 

[yogi]

the other thing i wanted to mention was that as soon as i open the file I get
the error message "microsoft excel has encountered a problem and needs to
shut down."

we tried extracting a single sheet that had a lot of graphs into a separate
file. that one worked just fine when i opened it with 2007. i did this to
test both small file size and also a page heavy on graphs.

This is working ok with the converter. The problem is that we have a
large (2mb) old excel file that will not convert. The conversion
process just seems to go on forever without ending. Any ideas?

2MB isn't a large Excel file. It's middle sized.

Anyway, what's in the file? Also, do you now have both the
original .XLS file and a [partially] converted .XLS[XMB] file? If so,
does the .XLS file still open correctly in Excel 2003? Does the .XLS
file open in Excel 2007? [Yes, Excel 2007 should be able to open .XLS
files.]

.XLS files have an annoying tendency to extend formatting too widely,
which is one of the reasons .XLS files tend to grow over time even
when there are no newly entered cells. It's possible this could be
your problem, and the conversion is taking forever because it's
extending nondefault formatting to row 65536 rather than applying it
to entire columns rather than to individual cells.

If you still have the original .XLS file, open it in Excel 2003 and
press [Ctrl]+[End] in each worksheet. Do you wind up in either column
IV or row 65536?