SmartListBuilder: Linking not working properly. Bug?
We have a third-party customization added to GP. The table is in our company
database and is accessible to add to GP. We can successfuly create a
SmartList that queries only this table. However, when we link this table to
another GP table, it doesn't work properly. I think I have isolated the
problem. I found the SQL in the DEXSQL logs and the link, while seemingly
correct in the SLB UI, is not generating the correct SQL code. See below for
the actual SQLthat SLB generated. The last line is " T2. = T1.SOPTYPE and
T2. = T1.SOPNUMBE"
Note that the field name for T2. is m...Deleting Non-Duplicate Rows
Have done tihs is the past, but can't remember how:
Have a sheet with 9500+ rows. Column C contains a storage bin number.
Want to delete all rows that DO NOT have a duplicate (trying to resolve
items that have a duplicate bin number.) Have sorted the sheet on
Column C. THX. . .
BillW's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=27516
View this thread: http://www.excelforum.com/showthread.php?threadid=470299
You could use a helper column of formulas:
=countif(c:c,c1)...too many different formatting cells
I can't open an excel document because whem I try to open it says that too
many different formatting cells.
How to resolve this and open this document?
XL: Error Message: Too Many Different Cell Formats
A few people have said that OpenOffice.Org has been able to open the file. Then
they clean it up and save it there. Then excel can open that cleaned up
http://www.openoffice.org, a 60-104 meg download or a CD
> I can't open an excel document because whem I try to open it says that too
>...Table requires Custom Linking to Excel
I have a table in Word 2000 with various columns. Each row represents one
order for a meal package. One of the columns indicates one of three baked
pies to order (apple, cherry or pumpkin). Another column indicates whether
or not the order has been paid or unpaid.
Is there a way to put a total number for each of the pie types ordered into
an Excel worksheet? Similarly, would there be a way to analyze all of the
rows, and for all rows with an unpaid status, multiply this number by the
cost for each meal package, and display this result in an Excel worksheet as
Thanks...Use cell value as cell address
Hello everyone. I have a worksheet "Main" of 39,000 rows in which column
B contains a number between 1 and 7,500. Column C is an empty column I
The second sheet, "Names" in the book contains a single column - A -
of 7,500 names.
I want to get the value from the second sheet that matches the number
column of the first sheet. In other words, if "Main" cell B3 contains
3780, I want to put the value from "Names" cell A3780 into "Main" C3.
How do I do this please?
Message posted from http://www.ExcelForum.com/
tr...Formulas showing in cell???
I keep getting a formula showing in the cell after I edit i
(occasionally). Show formulas is turned off and edit in cell is on.
How can I make the formula go awaw and simply show the results whic
when edited the results shows correctly?
Message posted from http://www.ExcelForum.com
probably the cell is formated as 'Text' change the cell format to
'General' and re-enter your formula
> I keep getting a formula showing in the cell after I edit it
> (occasionally). Show formulas is turned off and edit in cell is on.
>...How to get total "conditional sum of cells" in a column?
I have dollar amounts in one col, and status in another. I want the
sum of those dollar amounts where the corresponding status cell is
empty (blank). How do I do this?
Thanks for any hints,
Status in Column A and dollar amounts in Column B:
In Perth, the ancient capital of Scotland
and the crowning place of kings
Replace @mailinator.com with @tiscali.co.uk
"sherifffruitfly" <email@example.com> wrote in message
news:firstname.lastname@example.org...How to only "paste values" of cells that are not "hidden"?
In my document, many columns are hidden. Say column B is hidden,
and I need to copy columns A and C and paste values into another
Excel document. How can I do that? When I select columns A and C, copy
and paste values, the other document contains columns A,B and C, instead of
just columns A and C.
Don't drag-select, control-click A and then C, for scattered-selection.
On Sun, 17 Jul 2005 16:33:01 -0700, Sam <Sam@discussions.microsoft.com>
> In my document, many columns are hidden. Say column B is hidden,
&g...passing non-field value into vba
I need to pass the line item sequence number (lnitmseq) from the sales
item detail entry window into vba. This isnt a visible field in the
window, so i cannot "add field to vba" using the TOOLS --> customize
toolbar window. Anyone have any idea how this can be done?
Using the Modifier you can make the field visible, add it to VBA and then
remove the modified window or make the field invisible again.
While in the Window Layout mode, make sure that the Invisible fields are
shown (Layout >> Show Invisible Fields) and then change the Visual Property,
Visible = true and mov...pasting or moving formula cells without updating formulas
I have a flat spreadsheet with a results page at the end. The results page
contains a set of formulae which refer to various cell locations within the
body of the spreadsheet in order to return statistical results based on the
values in said cells. Now I'd like to add more data to my spreadsheet, so i
need to make it bigger; however, when I copy and paste, or select and drag
the cells containing the formulae, Excel updates the formulae so that they
refer to different cells which bear the same spatial relationship to the
formulae as the original referees did before the formulae were ...how do i copy a formula when cell references r not together
in cell reference H5 i have a formula H4*H3, I have copied this formula
through to DG5. In cell reference H7 I have a formula H6*H3 which i have also
copied through to DG7.I have formulas right down to cell reference H299
(H298*H3) Is there a quick way to repeat the copy bearing in mind the cell
references are not together ie H5, H7, H9 and so on.
Copy cells H6:H7, then select H6:H299 and pastespecial formulas. Just make sure your formula is
MS Excel MVP
"jon104" <email@example.com> wrote in message
news:DDAB488A-5CDA-47A2-AD...Scrolling through cells
I'm having trouble scrolling through the cells using the arrows. When I was
typing in a cell I used to be able to press one of the arrow keys and it
would automatically go to the next cell. Now when I press the arrow key is
sticks the next cell in as part of a formula. I'm not sure what's happened
to change this. Can anyone help????
You are probably in Extend mode. This happens when you press F8. It shows "EXT" in the Status bar (to the right)
Press F8 again to deactivate this.
Microsoft MVP - Excel
"alice" &l...Overwriting a cell with a formula without deleting the formula
Hello. I am creating an Expense Report worksheet and have created a simple
formula that will calculate mileage based on total miles. Below is my
A B C
1 Expense Type Acct. Code Total Miles Amount
2 Airfare 11111
3 Mileage 22222 20
I am trying to figure out a way to create a conditional formula so that IF
Expense...Highlight changes within cell
Using Excel 2003
I need to highlight the changes I’m making within a cell.
For example: In cell B2, is the customer’s original order quantity of 200. I
revise it to show 225 and I’d like the cell to be highlighted in yellow. I
can then copy and paste the info into an email to show the customer which
items have been revised.
I’ve tried using Track Changes, but it seems that I have to click on the
Track Changes button each time I open the workbook. It also doesn’t keep the
revision highlighted for a copy and paste.
I have 20+ worksheets within the workbook an...How do I use text in a cell as a range name in a formula
If cell A1 had the text TEST in it
and TEST is the name I have given to a group of cells using the name box
what formula can I use to give me the sum of TEST, thats is the sum of the
cells in the group called TEST.
I understand that I can simply have =SUM(TEST), but I want the formula to
refer to Cell A1 to get the name ie =SUM(A1) doesn't work obviously
Any help appreciated
In this case, you want to use the INDIRECT function. E.g.,
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"Kiwi" &...deleting duplicate cells
I am back again... Thanks to everyone's help here last time, I was able
to finish all my work and do it correctly.
Ken- I asked last time i was here about deleting duplicate cells. Some
of the names(address, etc) are repeated in my sheet. I want to delete
the extra cell of the people who are in here twice. Not jus the cell
but their record, name, address, city, state zip when they are in their
twice so that they will only be listed once.
You told me how to do this once but i cant find where it is on the
board. Thanks for all the help.... BR4
-----------------------------------------...Bug? Multiple values in merged cells
I found that merged cells can contain multiple values.
Steps to reproduce:
Type 1,2,3,4 in a1:d1
type sum(a1:d1) in e1
Select a1:b1 and merge
Warning : MultipleData, overwrite?
Say yes to merge
Select the merged a1:b1 cells
No warning.. no overwrite.
c1:d1 are now merged
BUT d1 still contains a value...
and the SUM of a1:d1 = 8 !!
Also happens with FormatPainter etc
Behaviour observed in xl97,xlXP and xl2003
Error checking will find no fault in the sheet...
and you can spend ages to find out WHY your cross
sums dont match!
(although now that i fou...Find Blank Cells
I wish to replace the blank cells in a large database with
a zero (0). I cannot figure out how to find a blank cell
using the Find and Replace option under the Edit menu.
Can anyone show me the way?
I always use CTRL+H to bring up the find and replace menu, leave the
fine part empty, and put in what you want to replace it
with....however, I do notice you say in a "database"? Do you mean in
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.Exc...COLOUR CHANGE IS A CELL
What I am trying to do is use say a red coulured cell but when text is added
to the cell it changes colour to green.
The other thing if possible a drop down menu in a cell so when clicked on it
offers three of four selection
And once one wes highlighted it would show in the cell.
Thankls for your help it is really apprereciated.
You can use data validation to create a dropdown list in a cell. There
are instructions in Excel's help, and here:
> Cyber taz
> What I am...Updating Links in PowerPoint 2007
I have pasted in links from Excel 2007 to a PowerPoint 2007 file. Both files
are on same drive. When I open the PowerPoint I get a message "Some linked
files were unavailable and can't be updated." What is going on? How do I
In article <8D3689EE-EA7C-407F-B757-45CEDAE78976@microsoft.com>, Txm49 wrote:
> I have pasted in links from Excel 2007 to a PowerPoint 2007 file. Both files
> are on same drive. When I open the PowerPoint I get a message "Some linked
> files were unavailable and can't be updated." What is going on? How do...CSV file with 13space characters in blank cells
In my office we've just received a recurring report
which has been modified (by someone. Previously
(a CSV file) the Data area (say A1:M30 ) had numbers
or blank cells representing 0 (zero) values.
Now, however the blank cells ARE NOT BLANK (although
they appear blank) all cells without numbers have 13
hard-space values in them, which is causing #VALUE!
I temporarily added an intermediate sheet with formula:
to eliminate the #Value! problem; Is there a better way?
I'm sure there is, just not certain at this point in time.
Any ...linking a date colmn with outlook calender
I am using a financial sheet, on which loan is given to customer(s) fo
6 months (180 days), when the 6 months competted, some time
fogot/,miss to collect the loan back from customer(s). So, i want t
import the same sheet to outlook calender so it automatically inform m
on exact date (after completing 6 months).
Can some one help me to sort out.
Message posted from http://www.ExcelForum.com
Seems preety complicated.
Else plot the due dates in excel and conditionally format the cells t
be highlighted in case date is the present day i.e today
Message posted from http://ww...insert a link/shortcut to a file on comuter in a contact window
I am trying to add a link or shortcut to a file on my computer in a contact
window, in the lower window of the contact When I drag a file in that box it
actualy creats a copy in a certain folder in Microsoft, but then its hard to
find the file I want to Insert only a Link or shrtcut to the file. Can
anyone have an idea?
pl;ace your cursor in the white window of the Contact. Then Insert | File,
single click the file you want and use the tiny drop down arrow, bottom
right corner to select: Insert as Hyperlink.
"Jacob" <firstname.lastname@example.org> wrote in message
news:O5g%23hYD2G...Link and paster special
I have some table cells that I want to link to other areas on the same Word
I have done the Copy and Paste Special and all works fine..unless.
Say that the info in the cell say "today is a nice day" If I change it to
"today is a nice days", I added the s, ...then the copied area doesn't update
to show the added letters.
Is there a way to format a table cell to select the entire cell when doing a
copy or am I missing something?
I have tried the paste formatted, non formatted and HTML
Make sure to copy the whole cell ...Hidden Cells #2
I have user who has a spreadsheet and the cells on colum A appear to be empty. However when you click on a cell, the information appears above in the field where you can change text. That field has a lower case fx in front of it. Anyhow I think the user clicked a setting the hides the information in the cell.
Any help would be appreciated.
Maybe the font is set to white
Regards Ron de Bruin
"Anthony" <Anthony@discussions.microsoft.com> wrote in message news:91D96835-23ED-4985-BE65-45187475EE03@microsoft.com...
> I ha...