OT: Hexcel
Bookmark this page:
 Yahoo!
 Google
 Windows Live
 del.icio.us
 digg
 Netscape
|
|
||||||||||||||||||||||||||||||||||
|
Posted by Robert Baer on July 20, 2008, 8:10 pm
Please log in for more thread options I have a spreadsheet made years ago, so do not ask what i did to get the following problems. 1) It is impossible to print all 6 sheets to file; the first 4 print to <name1>, the 5th to <name2> and the last to <name3>.
Absolutely NO clue as to how to fix this crap.
2) Sheet 6 looks larger than sheets 1-5 even tho all cells are exactly the same size and the font(s) aer exactly the same. Again, absolutely NO clue as to how to fix this crap. 3) In any spreadsheet, insert a sheet and i get lots of horizontal and vertical lines; again impossible to remove ("format" has ZERO effect). A copy from a decent-looking sheet has no effect. Like i said, M$ junk. Anybody know how to fix this garbage? | ||||||||||||||||||||||||||||||||||
|
Posted by Jamie on July 20, 2008, 7:50 pm
Please log in for more thread options > I hate M$ junk!
Switch to open office? :)
> I have a spreadsheet made years ago, so do not ask what i did to get > the following problems. > 1) It is impossible to print all 6 sheets to file; the first 4 print to > <name1>, the 5th to <name2> and the last to <name3>. > Absolutely NO clue as to how to fix this crap. > 2) Sheet 6 looks larger than sheets 1-5 even tho all cells are exactly > the same size and the font(s) aer exactly the same. > Again, absolutely NO clue as to how to fix this crap. > 3) In any spreadsheet, insert a sheet and i get lots of horizontal and > vertical lines; again impossible to remove ("format" has ZERO effect). > A copy from a decent-looking sheet has no effect. > > Like i said, M$ junk. > > Anybody know how to fix this garbage? -- "I'd rather have a bottle in front of me than a frontal lobotomy" "Daily Thought: SOME PEOPLE ARE LIKE SLINKIES. NOT REALLY GOOD FOR ANYTHING BUT THEY BRING A SMILE TO YOUR FACE WHEN PUSHED DOWN THE STAIRS. http://webpages.charter.net/jamie_5" | ||||||||||||||||||||||||||||||||||
|
Posted by mpm on July 20, 2008, 8:19 pm
Please log in for more thread options > =EF=BF=BD =EF=BF=BDI hate M$ junk!
t i did to get
> =EF=BF=BD =EF=BF=BDI have a spreadsheet made years ago, so do not ask wha= > the following problems.
> 1) It is impossible to print all 6 sheets to file; the first 4 print to > <name1>, the 5th to <name2> and the last to <name3>. > =EF=BF=BD =EF=BF=BDAbsolutely NO clue as to how to fix this crap. > 2) Sheet 6 looks larger than sheets 1-5 even tho all cells are exactly > the same size and the font(s) aer exactly the same. > =EF=BF=BD =EF=BF=BDAgain, absolutely NO clue as to how to fix this crap. > 3) In any spreadsheet, insert a sheet and i get lots of horizontal and > vertical lines; again impossible to remove ("format" has ZERO effect). > =EF=BF=BD =EF=BF=BDA copy from a decent-looking sheet has no effect. > > =EF=BF=BD =EF=BF=BDLike i said, M$ junk. > > =EF=BF=BD =EF=BF=BDAnybody know how to fix this garbage? There are lots of possibilities here. The first thing to try is to see if any cells are merged. If so, formatting those may have little, if any visible effect on screen. I consider myself an Excel expert!! But you have really not given me enough to go by. Like what version of Excel, etc.. Is all data static, or is Excel grabbing live data, or SQL fetches, etc... For the horiz & vert lines, these are controlled under File - Page Setup - Sheet - Print Guidelines Checkbox. File - Page Setup - Page will adjust scaling (your problem with sheet 6?) If that fails... Another thing you might try, is open a new, blank workbook. Then, open the one you're having trouble with and copy each page (select all, copy, paste) into the new workbook sheet-by-sheet and see if that helps. (This assumes the worksheet / workbook is not password protected). If so, unprotect either or both as needed. You could also have a major problem with your personal.XLS file (usually hidden), and you can blow this away and Microsoft will re- create a new fresh, uncorrupted version. Note: If this is the problem, it will usually affect all workbooks. (with some caveats, such as sharing a open file on a network, etc..) Google search the personal.xls corruption issue. Or, your copy of Excel could be corrupted. Hey, it does happen, but it's pretty rare. If you take the file to another machine running Excel and it behaves the same, then you can probably rule out Excel. Also, check for page breaks & pages per sheet setting under File - Page Setup - Sheet If all else fails, you can run a quick VBA script to remove all formatting. If you're lazy, I think the Excel Power Utilities Pak has a function for that. Google search it. Or I'll send you my script. (Currently on another PC) Otherwise, I don't know off the top of my head how to help you, as I would need a lot more to go on. Good luck. | ||||||||||||||||||||||||||||||||||
|
Posted by Robert Baer on July 22, 2008, 5:54 pm
Please log in for more thread options mpm wrote:
>
>>� �I hate M$ junk!
>>� �I have a spreadsheet made years ago, so do not ask what i did to get >>the following problems. >>1) It is impossible to print all 6 sheets to file; the first 4 print to >><name1>, the 5th to <name2> and the last to <name3>. >>� �Absolutely NO clue as to how to fix this crap. >>2) Sheet 6 looks larger than sheets 1-5 even tho all cells are exactly >>the same size and the font(s) aer exactly the same. >>� �Again, absolutely NO clue as to how to fix this crap. >>3) In any spreadsheet, insert a sheet and i get lots of horizontal and >>vertical lines; again impossible to remove ("format" has ZERO effect). >>� �A copy from a decent-looking sheet has no effect. >> >>� �Like i said, M$ junk. >> >>� �Anybody know how to fix this garbage? >
** The "Excel" is courtesy of M$ Office 2000 Premium; other than macros
> > There are lots of possibilities here. > The first thing to try is to see if any cells are merged. > If so, formatting those may have little, if any visible effect on > screen. > > I consider myself an Excel expert!! > But you have really not given me enough to go by. Like what version > of Excel, etc.. > Is all data static, or is Excel grabbing live data, or SQL fetches, > etc... that have local references, data is static; NO networks, NO SQL. >
** Will check that..
> For the horiz & vert lines, these are controlled under File - Page > Setup - Sheet - Print Guidelines Checkbox. File - Page Setup - Page > will adjust scaling (your problem with sheet 6?) >
** NO protections or passwords; will try this also.
> If that fails... > > Another thing you might try, is open a new, blank workbook. > Then, open the one you're having trouble with and copy each page > (select all, copy, paste) into the new workbook sheet-by-sheet and see > if that helps. (This assumes the worksheet / workbook is not password > protected). If so, unprotect either or both as needed. >
** "personal.XLS" file?? Sounds like a M$ crock..
> You could also have a major problem with your personal.XLS file > (usually hidden), and you can blow this away and Microsoft will re- > create a new fresh, uncorrupted version. Note: If this is the > problem, it will usually affect all workbooks. (with some caveats, > such as sharing a open file on a network, etc..) Google search the > personal.xls corruption issue. >
** All sheets are set the same - been double checked.
> Or, your copy of Excel could be corrupted. Hey, it does happen, but > it's pretty rare. > If you take the file to another machine running Excel and it behaves > the same, then you can probably rule out Excel. > > Also, check for page breaks & pages per sheet setting under File - > Page Setup - Sheet I have done some historical "forensics and found a 4-page Quattro (DOS, before Win95) spreadsheet where the info was in one rather wide format; Most likely openened in some version of Hexcel then a 5th sheet added as each sheet is a year for a business plan forecast. The 6th year was added much later. >
** Thanks for the pointers!
> If all else fails, you can run a quick VBA script to remove all > formatting. > If you're lazy, I think the Excel Power Utilities Pak has a function > for that. > Google search it. Or I'll send you my script. (Currently on another > PC) > > Otherwise, I don't know off the top of my head how to help you, as I > would need a lot more to go on. Good luck. | ||||||||||||||||||||||||||||||||||
|
Posted by Robert Baer on July 22, 2008, 8:25 pm
Please log in for more thread options Robert Baer wrote:
> mpm wrote:
> >>
>>> � �I hate M$ junk!
>>> � �I have a spreadsheet made years ago, so do not ask what i did to get >>> the following problems. >>> 1) It is impossible to print all 6 sheets to file; the first 4 print to >>> <name1>, the 5th to <name2> and the last to <name3>. >>> � �Absolutely NO clue as to how to fix this crap. >>> 2) Sheet 6 looks larger than sheets 1-5 even tho all cells are exactly >>> the same size and the font(s) aer exactly the same. >>> � �Again, absolutely NO clue as to how to fix this crap. >>> 3) In any spreadsheet, insert a sheet and i get lots of horizontal and >>> vertical lines; again impossible to remove ("format" has ZERO effect). >>> � �A copy from a decent-looking sheet has no effect. >>> >>> � �Like i said, M$ junk. >>> >>> � �Anybody know how to fix this garbage? >>
>> >> >> There are lots of possibilities here. >> The first thing to try is to see if any cells are merged. >> If so, formatting those may have little, if any visible effect on >> screen. >> >> I consider myself an Excel expert!! >> But you have really not given me enough to go by. Like what version >> of Excel, etc.. >> Is all data static, or is Excel grabbing live data, or SQL fetches, >> etc... >
> ** The "Excel" is courtesy of M$ Office 2000 Premium; other than macros > that have local references, data is static; NO networks, NO SQL. > >>
>> For the horiz & vert lines, these are controlled under File - Page >> Setup - Sheet - Print Guidelines Checkbox. File - Page Setup - Page >> will adjust scaling (your problem with sheet 6?) >
> ** Will check that.. > >>
>> If that fails... >> >> Another thing you might try, is open a new, blank workbook. >> Then, open the one you're having trouble with and copy each page >> (select all, copy, paste) into the new workbook sheet-by-sheet and see >> if that helps. (This assumes the worksheet / workbook is not password >> protected). If so, unprotect either or both as needed. >
> ** NO protections or passwords; will try this also. > >>
>> You could also have a major problem with your personal.XLS file >> (usually hidden), and you can blow this away and Microsoft will re- >> create a new fresh, uncorrupted version. Note: If this is the >> problem, it will usually affect all workbooks. (with some caveats, >> such as sharing a open file on a network, etc..) Google search the >> personal.xls corruption issue. >
> ** "personal.XLS" file?? Sounds like a M$ crock.. > >>
>> Or, your copy of Excel could be corrupted. Hey, it does happen, but >> it's pretty rare. >> If you take the file to another machine running Excel and it behaves >> the same, then you can probably rule out Excel. >> >> Also, check for page breaks & pages per sheet setting under File - >> Page Setup - Sheet >
> ** All sheets are set the same - been double checked. > I have done some historical "forensics and found a 4-page Quattro > (DOS, before Win95) spreadsheet where the info was in one rather wide > format; Most likely openened in some version of Hexcel then a 5th sheet > added as each sheet is a year for a business plan forecast. > The 6th year was added much later. > >>
>> If all else fails, you can run a quick VBA script to remove all >> formatting. >> If you're lazy, I think the Excel Power Utilities Pak has a function >> for that. >> Google search it. Or I'll send you my script. (Currently on another >> PC) >> >> Otherwise, I don't know off the top of my head how to help you, as I >> would need a lot more to go on. Good luck. >
...oh, forgot: there is NO "personal.XLS" file anywhere (search gave
> ** Thanks for the pointers! "not found") on the hard drive; also i can see all hidden and system files and it aint nowhere (unless in that garbage pit mistrakenly called the "registry"). | ||||||||||||||||||||||||||||||||||
| Similar Threads | Posted |
| OT: Hexcel | July 20, 2008, 8:10 pm |