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.
Robert Baer 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?
Switch to open office? :)
-- "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"
> 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...
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.
<robertb...@localnet.com> wrote: > I hate M$ junk!
If the MS stuff worked, I would be out of business.
> Anybody know how to fix this garbage?
My guess(tm) is that you have an non-updated version of Excel.
1. From your unspecified version of Excel, run: Help -> Detect and Repair Have you Excel or MS Office disks handy.
2. Updates? If you have Excel XP (2002) or later, use Windoze or Microsoft Update. Be sure to use IE6 or IE7. http://windowsupdate.microsoft.com
3. If you have Excel 2000 go to: http://office.microsoft.com Be sure to use IE6 or IE7. In the upper right hand corner, hit "Check for Updates". You'll get a new page. On the left is a column labelled "Downloads". For Office 2000, click on: Updates -> Office Update It will try to authenticate, authorize, and drive you insane with DLL installs. Just do it. Eventually, you will be blessed with a total of about 100Mbytes of assorted downloads depending on Office version. Download and install literally every update. Figure on 3-4 download ordeals punctuated by an equal number of reboots. You will need your Office 2000 or Word 2000 cdrom.
4. If you're using the spreadsheet that came with MS Works, it's not Excel and does weird things when fed Excel spreadsheets. Same ordeal as above. Do the updates.
If that doesn't fix it, come back with an organized complaint that includes exact product name, version numbers, and operating system.
mpm wrote: > On Jul 20, 7:10 pm, Robert Baer <robertb...@localnet.com> 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.
Jeff Liebermann wrote: > On Sun, 20 Jul 2008 17:10:11 -0700, Robert Baer > <robertb...@localnet.com> wrote:
>> I hate M$ junk!
> If the MS stuff worked, I would be out of business.
>> Anybody know how to fix this garbage?
> My guess(tm) is that you have an non-updated version of Excel.
> 1. From your unspecified version of Excel, run: > Help -> Detect and Repair > Have you Excel or MS Office disks handy.
> 2. Updates? If you have Excel XP (2002) or later, use Windoze or > Microsoft Update. Be sure to use IE6 or IE7. > http://windowsupdate.microsoft.com
> 3. If you have Excel 2000 go to: > http://office.microsoft.com > Be sure to use IE6 or IE7. In the upper right hand corner, hit "Check > for Updates". You'll get a new page. On the left is a column > labelled "Downloads". For Office 2000, click on: > Updates -> Office Update > It will try to authenticate, authorize, and drive you insane with DLL > installs. Just do it. Eventually, you will be blessed with a total > of about 100Mbytes of assorted downloads depending on Office version. > Download and install literally every update. Figure on 3-4 download > ordeals punctuated by an equal number of reboots. You will need your > Office 2000 or Word 2000 cdrom.
** Are you insane? Since i am on dial-up, that would take a few DAYS making the ASS-u-ME-ption that there were no data drop-outs. Not going to happen.
> 4. If you're using the spreadsheet that came with MS Works, it's not > Excel and does weird things when fed Excel spreadsheets. Same ordeal > as above. Do the updates.
> If that doesn't fix it, come back with an organized complaint that > includes exact product name, version numbers, and operating system.
>> On Jul 20, 7:10 pm, Robert Baer <robertb...@localnet.com> 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.
> ** Thanks for the pointers!
OK; did a few things that were of a little help. 1) Created a new spreadsheet, made 6 sheets. Comment: ALL sheets had the damn lines which could not be removed. 2) Formatted all sheets the same: courier 10, no protection. 3) "Copied" each sheet from the old spreadsheet to the new spreadsheet. "Copy" does not copy everything, so i do not call it "copy" but a half-assed attempt to gull the user into thinking that it works. *The non-lined attribute is NOT copied. *Page setup is all AFU, had to change that on all sheets. *Formatting of all cells not copied; some were x.xxx when original was x.x *References to other sheets were totally screwed up; they were ALTERED to refer to the _original_ spreadsheet, so here "copy" screws the user as one must laborously fix all of the damn references (if the user is lucky to remember where they all were). *The sizes of the various cells were *almost* the same between sheets - which is good, so on that aspect i cannnot complain that the larger size on the old sheet6 did not get copied. But why "almost"? *Printing the whole workbook to Acrobat resulted in all 6 pages (sheets) without a hitch - a large improvement. What i have: M$ Excel 2000 build 9.0.2720 (from the "help" menu). Have not tried the "repair" route. I understand that there is a non-obvious "trick" to get rid of those damn horizontal ahd vertical lines (in a given sheet), so i tried fiddling around to no avail.
>> On Jul 20, 7:10 pm, Robert Baer <robertb...@localnet.com> 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.
> ** Thanks for the pointers!
...oh, forgot: there is NO "personal.XLS" file anywhere (search gave "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").
On Jul 22, 8:22 pm, Robert Baer <robertb...@localnet.com> wrote:
> OK; did a few things that were of a little help. > 1) Created a new spreadsheet, made 6 sheets. > Comment: ALL sheets had the damn lines which could not be removed.
You mean Horiz & Vertical lines on the screen, or on paper?
If on screen, click Tools - Options - View - and uncheck the Gridlines box. (or, I guess you can set the gridlines to the same as the background color - which is all I think this box does?)
If on printed paper, go to File - Page Setup - Sheet and uncheck gridlines there.
> 2) Formatted all sheets the same: courier 10, no protection.
Sounds good. Can't hurt anyway....
If they're just the wrong sizes (i.e., in the way, but not objectionable), then you can select the columns and rows and either autoformat or set as appropriate.
> 3) "Copied" each sheet from the old spreadsheet to the new spreadsheet. > "Copy" does not copy everything, so i do not call it "copy" but a > half-assed attempt to gull the user into thinking that it works. > *The non-lined attribute is NOT copied. > *Page setup is all AFU, had to change that on all sheets. > *Formatting of all cells not copied; some were x.xxx when original > was x.x > *References to other sheets were totally screwed up; they were > ALTERED to refer to the _original_ spreadsheet, so here "copy" screws > the user as one must laborously fix all of the damn references (if the > user is lucky to remember where they all were).
My bad. I should have warned you there is also a "Paste Special" command, which will give you greater control over what actually gets pasted (from the copy).
> *The sizes of the various cells were *almost* the same between sheets > - which is good, so on that aspect i cannnot complain that the larger > size on the old sheet6 did not get copied. But why "almost"?
To retain the cell height & width, etc... you would have had to use the Paste Special command. But in this case, you were probably right NOT to, as you are trying to rid all the formatting and start with something clean(er) and fresh.
> *Printing the whole workbook to Acrobat resulted in all 6 pages > (sheets) without a hitch - a large improvement.
Congrats!
> What i have: M$ Excel 2000 build 9.0.2720 (from the "help" menu). > Have not tried the "repair" route.
It sounds like it probably does not require repair. (?) But it does appear the default formatting is all screwy. I would re-check the personal.xls (or any other macros you might have).
That you could not find Personal.xls may in fact be the whole problem??!! See if you can find it under the VB macro editor I described above. If not, here are the directions to make a new one.
(Though honestly, I was 99.995% sure Excel would do this step on its own, if it ever needed to.) Unless, of course, the file really is there, and its corrupt. That seems to be the case here. Maybe best to make a new one anyway?
The macros in Personal.xls should apply to every workbook you ever open. Think of them as the primary default. Macros you create and save with the workbook will override these settings. It is generally not a good idea, in my opinion, to store private macros in public spaces (such as personal.xls). But ocassionally, it happens by mistake or ??
> I understand that there is a non-obvious "trick" to get rid of those > damn horizontal ahd vertical lines (in a given sheet), so i tried > fiddling around to no avail
I think I answered this one at the top of this reply. If not, let me know.
Also, not sure if I mentioned it previously but... Make sure the workbook is not shared too. Most likely it is not, or you would know it. If shared, be aware under Tools - Sharing there is an option to preserve the format using either your machine settings (what you want), or the last machine to touch the file(s). (What you don't want!)
Also, make sure you don't have any custom view sets. See: View - Custom Views etc... Again, you probably don't have these set.
