limit of named ranges
do you know ?
How many cells can man call under the same name in a worksheet?
Can we expand the limit with vba ?
How many "named range" (plage de cellules fusionn�es auxquelles j'ai donn�
un nom) can we put in a worksheet?
"Pascal" <email@example.com> wrote in message
> do you know ?
> How many cells can man call under the same name in a worksheet?
> Can we expand the limi...Excel Stock List
Im trying to make a stock list using excel that shows Product, Product Code,
Amount in Stock and Minimum Stock to Keep. What i want to do is when someone
takes some stock and reception remove it from the Amount in Stock list, as
soon as the Amount in the Stock List matches the amount in the Minimum Stock
to Keep column a pop up appears and tells us we need to re-order more stock
of the item that is running low. Anyone know how i would go about doing this?
many thanks in advance
Send me a small file showing the layout of your data and I'll help you
develop this thin...V lookup in Excel 2003
I have recently installed fresh copy of Office 2003, where I am unable to
find Vlookup function, (I couldnt see it in pop up also while I click on fx
Please help me on this issue as soon as possible, as heaps of work is
pending on my desk due to that.
Mail me at firstname.lastname@example.org
What happens if you just try using the function by typing it in?
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03
-------------------------------------------------------------------------...Excel 2000 #24
When I left click in a cell and then move my mouse, it
highlights all cells and I can't click on any menu items
or anything. The only way to close Excel is to go to
task manager and end task.
I've seen this type of thing happen with a mouse with a
scroll wheel. Sometimes the scroll wheel gets 'stuck'.
Press down on the scroll wheel a couple of times to see if
this clears up the problem.
>When I left click in a cell and then move my mouse, it
>highlights all cells and I can't click on any menu items
>o...Importing external data in plain text row format
I have data in the following format:
-------------------Begin Sample Data----------------------
Fernando E. Amuchastegui
Office of the County Attorney
115 S. Andrews Avenue
Fort Lauderdale 33301
Ronald J. Anania
Law Offices of Ronald J. Anania
10910 S W 10th Court
Eric J. Anders
Haley Sinagra Paul & Toland, P.A.
100 SE 3 Avenue
Fort Lauderdale 33394
Hal B. Anderson
Billing Cochran H...Olap data views
I've deployed a farm solution with SQL Server 2005, Project server 2007 and
windows Server 2003 SP2.
I configured Project Server 2007 default cube sucsessfuly and I can create
views and see them in PWA Data Analysis.
I created a new project Data Analysis Services in Visual Studio. I deployed
it remotely and I can see the New cube deployed if I connect to Analysis
Services SQL Services Management Studio.
Problem start in PWA, because i can't see the newly deployed cube. I only
see the default cube created in pwa interface if i go to "server settings...In Excel
I want to effect a mass change to the sign of numeric values in a range of
cells (rows and columns).
put -1 in an empty cell, copy it, select the range of cells to be
modified, select Paste Special and pick Multiply.
> I want to effect a mass change to the sign of numeric values in a range of
> cells (rows and columns).
Put -1 in an un-used cell and copy it. Then select the cells you want to
Edit > PasteSpecial > multiply
Gary''s Student - gsnu201001
> I want to effect a mass ch...smartlist export to excel with large record sets
I read with interest a posting on 2/19/07 and the responses. The issue
raised was how long it took to export a large record set (20,000 records)
from Smartlist to Excel. I wish that speed was my only problem. In our
case, when attempting to export as few as 2000 smartlist records, the
computer freezes, and both excel and GP have to be restarted. We are using
GP version 9 and Excel 2003. Similar thing happened with GP 8, and happens
on other workstations, not just mine. Woudl really appreciate some pointers.
Your problem is probably memory. First RAM should be 2 gig or b...Multiple Instances of Excel on 64-bit Win7
(NOTE: This is not a question about getting each Excel file to open in
a new instance. Please read carefully)
On my old system (WinXP Pro, Excel 2003, and Excel 2007):
- If no instances of XL are open and I open an XL file from Win
Explorer, XL would open (don't recall if it is same version every time
or if it would switch), and then the file would open.
- If an instance of XL is open and I open an XL file from Win
Explorer, the file would be opened in the existing instance of XL.
- If a...Excel: How do I set up a cell to click it to link a database?
I keep track of pricing info in a spreadsheet. I would like to "click on a
cell" to be directed to somewhere that I can keep a (purchsase) history
attached to that cell. Any ideas how I might be able to do that?
in the following, the counter - which determines the row
the historical data is entered - is maintained in cell
(1,30). The data you wish to periodically record is in
cell (10,1). when you run this macro, the data is
recorded in the next cell of row 3.
etcount = Cells(1, 30).Value
etcount = etcount + 1
Cells(1, 30).Value = etc...Outlook sharing data
A friend has a Novell 4.11 office network with several PCs running Windows
I guess he means they have a Novell server and other PCs running Windows 98
One PC has a broadband modem and runs MS Outlook for email.
What would it take to give Outlook running on one or more of the other PCs
access to the incoming emails and the ability to send emails. I think the
idea is that there would be only one email address but several people could
look through the incoming emails.
Brian Gregory. (In the UK)
To email me remove the letter vee.
What Outloo...data migration framework errors
We are using the data migration framework to migrate into a fresh CRM 1.0
installation. We are at the step where we run the CDFMigration Tool. It
runs and completes with no errors. It only migrates contacts, no accounts,
1. A clean restore of the cdf_mscrm, and CRM databases(which were backed up
right after we finished cleaning the data, before we started to migrate)
2. The cdf_"entity"_info table for account, activity, annotation, contact,
incident were empty: followed TechKBArticle #31094 from MSBTechKnowledge
which said to run:
Declare @Id As int
Declar...Exported File truncating cell data after 255 characters
I have exported a file in Excel format from MS Access. When I open the file
in Excel, the cells containing greater than 255 characters have been
truncated. Any way around this?
Excel will not display any characters if you put more than 255 in a cell.
Instead you'll get only # signs. So..exporting more than 255 (or maybe even
254) in a field is not likely to help you.
How many characters in the fields you're trying to export?
If not too many more than the 255 limit - you could use a query to break it
into two columns - first one getting the LEFT([textfield],200) and the next...Excel and Notepad: how avoid additional inverted commas after copy and paste?
If I write a multi-line text in a cell (then go down with alt+enter)
and after copy the cell pasting on Notepad, it display before inverted
commas and after textual content.
Instead, if I select directly the content from the formula bar, it
Do exist a way for copy and paste directly from the cell without
select from the formula bar?
Maybe with a macro?
I used the PutOnClipboard rout...Format date in excel 2000 like '31st January 2005' #6
Trying to set up field in Excel Data Source file so that the current date can
be input in letters typed in this format '31st January 2005'
Is it possible or am I stuck with dd/mmm/yy format?
Sorry for the repeated posts but I received a message that the system was
unable to send post. Can any unanswered ones be deleted please.
"Malcolm Agingwell" wrote:
> Trying to set up field in Excel Data Source file so that the current date can
> be input in letters typed in this format '31st January 2005'
> Is it possible or am I stuck with dd/mmm/yy format?...Copies of sent mail go to my Sent Items folder instead of other mailbox Sent folder.
I have two Exchange 2000 mailboxes, of which I use the Outlook client to
access. In this other mailbox, from which I occasionally send email, I
noticed copies of sent mail go to my own mailbox Sent Items folder instead
of the other mailboxes Sent Items folder.
Is this a feature that can be changed?
...how can i make a line chart from matrix(both row and col) of data
Select the data, and create the chart. By default, Excel is likely to use
the first column as X values (or category labels) and the first row as
series names, if the data is plotted by column. If Excel has trouble with
this, clear the top left cell of the range (the intersection of series names
and category labels/X values) and try again.
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
"Gourav" <Gourav@discussions.microsoft.com> wrote in message
news:CEA158CD-95F4-4903-BFBB...Method to Calculate APR in Excel?
Any suggestions or solutions would be appreciated.
Thanks & regards,
Your question is very broad - more detail would have helped, with an example
Here is one site that might help
Bernard V Liengme
Microsoft Excel MVP
remove caps from email
"PJF" <email@example.com> wrote in message
> Any suggestions or solutions would be appreciated.
> Thanks & regards,
"PJF" <pj...Count Images in an Excel Sheet
I have saved excel sheets with screen prints in it. I need to know if I can
get the total number of screen shots in a particular excel sheet.
Gary''s Student - gsnu201001
> I have saved excel sheets with screen prints in it. I need to know if I can
> get the total number of screen shots in a particular excel sheet.
PicCount = Activesheet.Pictures.Count
"Pankaj" <Pankaj@discussions.microsoft.com> wrote in message
Is there a way to cause Excel to display multiple rows of
worksheet tabs at the bottom of the excel workspace rather
than just one?
When a workbook has many worksheets it would be easier to
switch between different worksheets if they were visable.
I am aware that right clicking on the worksheet scroll bar
displays a list of the worksheets and that I can drag the
scroll bar on the lower right side of the workspace to the
right to allow more woorksheet tabs to be displayed but
these solutions don't really meet my needs.
Thanks to anyone that can help.
Try Right Click...extra quotation marks when excel ws is saved as txt file
I am trying to automate a process that creates a txt file
needed for an application. However, this text files needs
a set of double quotations, and also has some cells that
will have commas. When I save the excel worksheet that
contains this information, the text file ends up with
this """abcd""" instead of the original "abcd". Any cell
with commas is found in the text file with double quotes
surrounding it as well. Is there anyway to save the excel
worksheet as a text file and receive exactly what is
entered into the cells?
Note: I am a...Function Macros inspired by the recent "date in excel" thread.
I vaguely remember the use of function macros from an early version of
Excel. The date in excel thread reminded me of that because that might
offer a simple macro with programming not much different from just
writing a spreadsheet. IIRC this mini-spreadsheet could use data from
the calling spreadsheet to control its calculation.
IIRC, the function macro function is called with arguments just like an
ordinary Excel function is called. The return value or values of the
function is just what you can create using spreadsheet statements.
For example, suppose you have a starting point A and ...total in a frontsheet
Im having 20 subsheets that are build the same way.
Is there a function to sum cells for all 20 subsheets
into the frontsheet ?
"Bo" <firstname.lastname@example.org> wrote in message
> Im having 20 subsheets that are build the same way.
> Is there a function to sum cells for all 20 subsheets
> into the frontsheet ?
Something along these lines will work:
Sounds like it is better to use Data|Consolidate. This is in help file
"about consolidating data."
Consolidating by position
Consoli...how to find last cell in column with data
I have a very simple checkbook register. I would like to be able to
the ending balance in a specific cell at the top of the sheet. How can
I do this?
Let's say your balance is in column A from A2 to somewhere below.
Put in A1
(suggested by Sandy Mann)
> I have a very simple checkbook register. I would like to be able to
> the ending balance in a specific cell at the top of the sheet. How can
> I do this?
Gary...Trust access to the VBA project: Excel bug?, workaround required.
I'm fairly sure this is a VBA bug (comments welcome) and need a
In Excel 2007 'm using the the function below in an add-in to return
the access oft the VBA project. It appears to work correctly.
Private Function IsVBProjectAvailable() As Boolean
Dim lngAccessTest As Long
On Error Resume Next
lngAccessTest = ThisWorkbook.VBProject.VBComponents.Count
If lngAccessTest > 0 Then
IsVBProjectAvailable = True
IsVBProjectAvailable = False
....UNTIL you open a workbook containing macros. At ...