Export Excel (2007) data "as is" with arbitrary delimiter
Sat, 27 Feb 2010 17:32:59 -0800
I have a large Excel 2007 file containing text data that includes most
of the special characters on the keyboard. I need to create a
delimited text file without any processing of the data. That is, no
adding quotes or what have you.
I have tried the csv and tab-delimited text options. They all mess up
if ther ...
|
Personal.xlsb does not load automatically when I start Excel 200
Sat, 27 Feb 2010 16:40:56 -0800
Many thanks to MWMADISO
I was going nuts trying to get my macros back and no other website had the answer but here.
mwmadiso wrote:
Re: Personal.xlsb does not load automatically when I start Excel 2007
04-Sep-07
On Aug 1, 8:01 am, "James Graham" <grahamj...@hotmaiil.com> wrote:
Try clocking on ...
|
Ctrl+v doesn't work correctly
Sat, 27 Feb 2010 16:07:40 -0800 (PST)
I have Excel 2007 SP2. When I try to copy a formula using Ctrl+C and
paste using Ctrl+V, only the copied value (i.e., not the calculated
value using the formula) is pasted. When I copy using Ctrl+C and paste
using a right mouse click, it pastes correctly. Also, if I copy using
Ctrl+C and drag to the cells I want ...
|
test
Sat, 27 Feb 2010 21:33:17 -0000
Hi
Terry
...
|
Excel solver
Sat, 27 Feb 2010 23:24:31 +0800
I cannot distinguish between the "precision" and "convergence" setting in
the Solver. Anybody know about them. They seem to represent the same thing.
Just increasing the "precision" seems OK.
Thanks
...
|
Copy worksheet from one book to open workbook
Sat, 27 Feb 2010 05:09:01 -0800
Hi there
I hope you can help. I want to copy a worksheet from one book to the
workbook that is already open.
Example - open closed book called Owner Rep and copy the single sheet in
that book called sheet1 to the open book and replace existing sheet1.
thanks
Nev ...
|
Help with Vlookup Function
Fri, 26 Feb 2010 21:19:09 -0800 (PST)
Hey there.
I'm working with two sheets on a file. On the first sheet is a list of
students and the schools that they attend, with the student in column
A and the school in B. There are 200 rows. In sheet2, there is a list
of the schools and a countif for the number of students at each.
There are six student ...
|
|
|
summarize open issues
Fri, 26 Feb 2010 20:28:01 -0800
i have 3 different open issues lists on 3 tabs of a workbook that i want to
summarize the priority items onto one list on another tab. i want to tick off
items in priority order by a,b,c etc. and collect them in sorted priority
order all on one tab. does anyone have any ideas how i can do this? i
appreciate ...
|
sorting protected sheet not working
Fri, 26 Feb 2010 23:12:16 -0500
I'm getting the impression from my tests and reading various forums that
this is not possible even though the protection dialog box has an option to
allow sorting.
I'm creating a spreadsheet on the fly from MS Access vba based on some SQL
data. This is distributed to another company so they can fill in some ...
|
Excel page no. display OFF
Fri, 26 Feb 2010 19:00:47 -0800
>When I view my worksheet in the "Page Break Preview", I can see the Page Number shown on the worksheet as watermark. ...Is there any way I can get rid of it ...?
>>In short...no
That is a real, real pain. This splatch on my page consistently hides my texts & figures. It has been the single most infuriating, n ...
|
