D
dkingfish
I was having a problem with Excel 2000. I could save my spreadsheets but
they wouldn't re-open. Our IT people have Office XP and had no trouble
opening them. My work was stored on a server instead of my hard drive.
To resolve the problem, they installed Office XP on my computer and
recommended saving my work on my hard drive and use the server storage for
backup, which I did. Now my workbooks open ok, but XP Excel will hang and
crash when doing simple tasks, such as formatting, (i.e. borders, background
fill, etc.), on some of the workbooks that wouldn't open with XL 2000 but
not all. Any idea of why this is and what I can do to prevent this? I do
have bloated VB, (not very good at writing code yet), and lots of formulas
in the workbooks. One good feature is the auto-recovery function. It's
saved me quite a bit, but it's still frustrating redoing the work after a
recovery.
And there's a new problem too. I also use Access, but don't know enough to
make it do some of the sorting and compile totals on reports using than one
table or query, so I export or copy information to XL. When I copy and
paste data from Access and also web pages, numbers are formatted as text.
The result, a page full of error checking flags. My questions about this
are; How do I copy and paste without changing number formatting? And, Is
there a way to correct all of the errors at once when I end up with a page
full of error flags? The cells with errors are intermixed with no error
cells, so the correction tab doesn't appear after I highlight rows or
columns the have error and non-error cells. Reformatting the columns
doesn't remove the error flags, only clicking the correction.
they wouldn't re-open. Our IT people have Office XP and had no trouble
opening them. My work was stored on a server instead of my hard drive.
To resolve the problem, they installed Office XP on my computer and
recommended saving my work on my hard drive and use the server storage for
backup, which I did. Now my workbooks open ok, but XP Excel will hang and
crash when doing simple tasks, such as formatting, (i.e. borders, background
fill, etc.), on some of the workbooks that wouldn't open with XL 2000 but
not all. Any idea of why this is and what I can do to prevent this? I do
have bloated VB, (not very good at writing code yet), and lots of formulas
in the workbooks. One good feature is the auto-recovery function. It's
saved me quite a bit, but it's still frustrating redoing the work after a
recovery.
And there's a new problem too. I also use Access, but don't know enough to
make it do some of the sorting and compile totals on reports using than one
table or query, so I export or copy information to XL. When I copy and
paste data from Access and also web pages, numbers are formatted as text.
The result, a page full of error checking flags. My questions about this
are; How do I copy and paste without changing number formatting? And, Is
there a way to correct all of the errors at once when I end up with a page
full of error flags? The cells with errors are intermixed with no error
cells, so the correction tab doesn't appear after I highlight rows or
columns the have error and non-error cells. Reformatting the columns
doesn't remove the error flags, only clicking the correction.