CListCtrl with owner data and tooltip missing problem
I've a CListView derived class with owner data style and report view. My tooltip gets displayed and then overdrawn repeatedly. Traces in my lvn_getdispinfo and ttn_needtext handlers get called repeatedly. Are there known problems with tooltips and owner data? Any Ideas? Thanks, Jeff F
xxx2719
vc.mfc
33608 articles. 
0 followers.
0 Replies
868 Views
Similar Artilces:
hepl to solve my problem
Question Hi, I am new to access but i have the following to complete. Please help me out Interest rate scheme date period rate FDR 1/1/2000 1 YEARS 6 FDR 1/1/2000 2 " 8 FDR 1/1/2000 3 " 12 FDR 1/8/2000 3 13 FDR 15/1/2001 2 9 FDR 15/1/2001 3 12.5 FDR 1/12/2001 2 7 FDR 1/12/2001 3 11 RAP90 1/1/2000 90 5 RAP90 1/8/2000 90 6 RAP90 15/ 1/2001 90 6.5 RAP90 20/5/2001 90 6 RAP90 1/12/2001 90 5 RECEIPT SCHEME RECIEPT_DATE PERIOD AMOUNT FDR 1/2/2000 3 10000 RAP90 15/4/2001 90 15000 I want to computer to automatically renew the rec...
Pivot Table not pulling all fields or data
Hi All........ Without getting too verbose, I have a 900 row by 26 column database I am applying a Pivot Table to. The code seems to run fine, but it is not returning some of the fields, and of course the related data. I have tried reformatting the entire columns I am pulling from but no joy......however, when I reformat an errant cell from General to TEXT, that row comes in........and/or, if I change the value in one of the missing cells, it will bring that row in. The code runs fine, and was mostly derived by recording a macro in XL2k, but the data cannot be trusted becau...
Problem importing dll
Hi I have an application that used some external com dlls. So in my application code i've imported those dlls as #import "path of external.dll" and i'm using smart pointers to instantiate those coms as IExternaPtr Obj("External.Interface1"); The problem i'm facing that those external com dlls are not mine so every time they are modified by thier owner i've to recompile my code too with the latest dlls otherwise my code does not work and i get Obj = NULL in the above statement. Actually those external dlls are of a software that i've provided integratio...
How do I automatiicaly redefinie Source data range for a chart?
I have A Chart Defined by Category (X) values in Collumn B and Y values in Collumn C. Right now Both are defined by rows 4 to 114. I would like to be able to have the chart automatically redefine itself so if I put a value in C115 the chart would automaticaly set Y value range to be C4:C115 eithout having to manually define chart. Is this possible? If so how? I've tried OFFSET bu so far no luck. Hi, If you turn your data cells into a List, or Table in xl2007, the chart will auto expand. The named range approach will work if you set up the names correctly. See here for more info...
Problem with excluding an account from budget
I want to see my credit card payments (i.e., transfers to a credit accounts) as an expenses in Money reports. I know that I should exclude credit accounts from budget to achieve it, but it's impossible: - I'm going to Account Settings, and "Include this account in the budget planner" option is set - Trying to clear this option simply does nothing - it's still set and doesn't change. Is it possible that I've forgot something else to do before excluding an account from budget? If that's really your goal, the only sane way is to track them that way from t...
Exchange data backup
I'm worried emails backup of the small office. Does SBS2008 Exchange server has a direct backup capability of whole mail database? How to backup every night Emails from server to external harddisk? Does Exchange server needs to be stopped before backup? Thanks SBS2008 Takes care of it. http://blogs.technet.com/sbs/archive/2008/11/03/introducing-sbs-2008-backup.aspx look at the comments section Russ -- Russell Grover - SBITS.Biz [SBS-MVP] MCP, MCPS, MCNPS, SBSC Microsoft Certified Small Business Specialist 24hr SBS Remote Support - www.SBITS.Biz Question or Seco...
Data Save error
GP Ver 6.0. Recently I am facing an error with normal users unable to save records, where as the system administrator is able to save the same information. Please advice on this error, what has to be done. I have disabled the windows user ID of the Database owner. Thinking of this made Dynasa as the DBO. Database is having enough free space available. Hi How big is the company database? Is it over 10GB? Regards James "Matthews" <Matthews@discussions.microsoft.com> wrote in message news:3FF3F553-5B18-4D8A-B65E-8A253BF94BB2@microsoft.com... > GP Ver 6.0. Recently I...
extension DLL problems
I have CPropertySheet class with three CPropertyPage" classes in an extension DLL. I compile it, and run it. I get the .LIB and the .DLL files etc. in the client application I incluce the .LIB file and then I have add a button which when pressed will attempt to run the following code: CPropertySheet myWizard("Import wizard", this, 0); myWizard.DoModal(); this code produces the following error: "Debug assertion failed!" File: afxwin1.inl Line: 22 what is to be done? prg wrote: > I have CPropertySheet class with three CPropertyPage" classes in an > e...
Archive Problem
Dear All I work for an organisation that works in the dark ages. We use Outlook 98 (8.5.5603.0) with a basic build of NT4 (Service pack 6). When we use the archive functunality from the file menu we find that on some emails earlier than the date specified are not archived to the desired folder. I do not work for IT and cannot update service packs for outlook. Can anyone advise me what could be wrong? Was this a bug in this version. Sometimes some files would be archived and not all. What date is used? Is it the object's creation date? It makes no difference whether you have t...
Tab Control Problem
I'm just wondering how I can add controls to tab control pages that are bound to fields from different tables. I have 3 tables (road, track and gym) with similar named fields and I want to create a tab page for each table. Unfortunately, my tab control form only allows me to view and set controls for one table. So even though I might have a control bound to a field from table 'road', the information i enter goes to the table 'track' because that is the default table for the tab control form. My manual says I should be able to send and view info from different tables using ...
Outlook 2000 Folder Size Problem
I've created personal folders and rules for incoming mail. I've also deleted mail from Sent, Deleted Items, Etc. I think the problem is somewhere else...I checked the Folder Size for all of the folders under Outlook Today and the Total Size (Fld+SubFld): is 27900K. However, in the detail below, it does not add up to 27900K (only about 1200K). Could this be some kind of registry issue? I can't send email because the exchange server tells me that my box is full. Can anyone help with this? >-----Original Message----- >Hi Rob, >I take it that you are on an exc...
Problem Opening Notebooks on New Server
I have a small office and we all store and use notebooks on our server. We moved all of our data to a new server yesterday, and now when we try to open the notebooks we get a message that says: "OneNote needs a password to sync some of your notebooks", and we are unable to open the notebooks. Interestingly, if we open the notebook through a mapped drive to the location, we get the error. But, if we navigate directly to the notebook through the network, it will open with no error. We are having no other problems with this mapped drive. Thanks! ...
problem with starting thread
During debugging if we go over the following line of code: m_pCalculateThread = AfxBeginThread(UpdateDocThread, this); the thread DOES NOT start, but if we go into AfxBeginThread function, the thread DOES start. Any suggestions? Thanks in advance! Maybe you can look in the threads window during the debug. You could set execution to a thread using that too. "Leonid Nikolayev" <lenikn@gmail.com> wrote in message news:68e06e88.0409090843.e1b6c45@posting.google.com... > During debugging if we go over the following line of code: > m_pCalculateThread = AfxBeginThread(Upd...
Worksheet protection problem
I am using Excel 2000, wanting to protect certain cells, but allow user to filter using autofilter, etc. and how would I do this? Thanks, Jayne Private Sub Workbook_Open() Worksheets("Sheet1").EnableAutoFilter = True Worksheets("Sheet1").Protect UserInterfaceOnly:=True End Sub Right click on the Excel icon next to File in the menubar choose view code paste the code Alt-Q to go back to Excel This runs every time the workbook opens. It protects the worksheet and allows users to use the AutoFilter dropdown lists. -- Regards Ron de Bruin (Win XP Pro SP-1 XL2002...
cell range not changing when refreshing linked data- sumproduct fo
The cell range is not updating correctly to reflect the last row in the data sheet that is being refreshed. 5878 is the correct number of rows and 5824 is not. I can find and replace in my formulas to correct the problem, but it does it each time the data is refreshed. Any suggestions as to why? =(SUMPRODUCT((Expense!$B$2:$B$5878=$C$2)*(Expense!$C$2:$C$5878=$C$3)*(Expense!$W$2:$W$5824=$A6)*(Expense!$M$2:$M$5878))) I gave you the INDIRECT option y'day, but received no feedback from you in that thread. Looks like you're more interested in knowing why? One simple hunc...
Data vs. forms & Unload/reload questions
A .mdb file seems to encompass both the database and all the 'code' (forms, modules, and logic) used to CRUD the data in the tables. 1) Is there any way to separate the database from the code into separate files, eg. the db is mydata.mdb and the 'code is in a separate file, eg. code.mdb? 2) Say you have v1.0 of an app and the tables and attributes are populated with data. You then go and build v2.0 of the app, adding tables and columns to what already existed in v1.0, and perhaps moving some of the v1.0 attributes into different tables. What is the recommended way to unload/reloa...
Mobile Express set-up problem
After the installation, when I try to add some entities to the mobile application I get the following error: <?xml version="1.0"?> <configuration> <appSettings> <add key="DraftXmlLocation" value="C:\CrmMobileExpress\DraftXML.xml"/> <add key="PublishedXmlLocation" value="C:\CrmMobileExpress\PublishedXML.xml"/> <add key="Microsoft.Crm.Sandbox.Mobile.CrmServiceSdk.CrmService" value="http://triton:5555/MSCRMServices/2006/CrmService.asmx"/> <add key="Microsoft.Crm.Sandbox.Mobil...
Simple problem...
I am new to using Excel. I want to create a column that has the days of the month (1 Nov 03 thru 30 Nov 03). I know there is a way I can put the date in the first cell and then either paste or drag down and excel will add the dates sequentially, but I can't seem to figure out how to do it...I did it once before and don't remember the sequence that I followed. Could someone please post the steps on how to do this? Thanks! Bobby Bobby, put the date in a cell, A1, and click on the black square in the lower right hand corner and drag down -- Paul B Always backup your data before ...
csv-file problems with different regions
I have imported an American csv-file into a German Excel XP. The American $-values are separated by a "." while the German currency values are separated by a ",". So now my spreadsheet reads a value of $ 18.01 as 18. January. All values above 18.12 are ok. How can I avoid this problem? Or, can I change the values tediously one cell after the other? I have not found a way yet as even when I try to format a cell user defined it automatically changes to the format used in the German region. Thanks. Hans Temporarily change the regional settings on your computer to the same f...
Data Format: how can I re-format
The spreadsheet that was exported for me to use has the information in paragraph form: It is customer ID name and billing info but it is like a long series of address labels. I want to be able to have them listed under captions like company name, contact, address, city, etc.. so I can use the data. There is an empty row between each entry. Each entry is 3 or 4 rows. There are about 500 records so i dont want to manually set them up. Thanks Try tinkering around with these steps Assuming your list is in col A, data in A2 down (If data starts in A1 down, insert a new row for the co...
Help Problems with Outlook tool bar buttons
I'm hoping someone can offer advice on problems that I'm experiencing with Outlook 2003 toolbar buttons. Toolbar buttons usually work fine when I first open Outlook, but after I use a particular button once, it no longer works. For example, I can create a task, then assign the task. the next time I create a task, the assign button no longer works. I have to re-boot outlook to get the button to work again - then it only works once, etc, etc. This is also true of many other (but not all ) Outlook buttons, like "Save and Close", "Recurrence", and others. On...
Outlook Shutdown Problem
Office XP standard on XP Pro machine, in a Workgroup with a file server. Outlook works fine, however when closing Outlook, all indications are that it has closed, but opening Task Manager reveals that Outlook.exe is still running. If you try to shut puter down, Outlook "End Program" pops up. If you try to reopen Outlook, without killing in task manager, a second Outlook.exe pops up in Task Manager, but Outlook never opens. If you continue to click on Outlook icon, you can open a seemingly infinite number of Outlook.exe's. Have run "Detect and Repair" and have ...
Problems connecting to accounts
I am having problems downloading from most of my accounts. Some work but most do not, there is nothing I can do about this, is there? ...
Custom Type Charts Problem
I am using Custom Type Charts in Excel, which uses Pivot Table as the Data Source. The problem that I am facing here is that whenever I Refresh the data using the Refresh icon, the Custom Type charts LOOSE their formatting. To make my problem clearer, I am attaching a sample Excel sheet herewith. In the sample file, go to 3rd sheet "Custom Type Chart" and have a look at the "Tubes" chart. Now click on the "!" Icon (this is the Refresh icon). The formatting of the chart changes. Try this out with the "Normal Chart". The formatting remains the same. ...
Display comments as data #2
thanks a lot , this worked exactly as required, the comment go converted to data Now just one more thing . is the vice versa possible i.e if i have dat in column A can it be shown as comment in column B. the reason i need this is bcos i am shifting some data with thei comments to MS access(Hence the need to convert omments to data) processing them and again converting them to excel (the need to conver data back to comments -- sonik ----------------------------------------------------------------------- sonika's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=...
Question Hi, I am new to access but i have the following to complete. Please help me out Interest rate scheme date period rate FDR 1/1/2000 1 YEARS 6 FDR 1/1/2000 2 " 8 FDR 1/1/2000 3 " 12 FDR 1/8/2000 3 13 FDR 15/1/2001 2 9 FDR 15/1/2001 3 12.5 FDR 1/12/2001 2 7 FDR 1/12/2001 3 11 RAP90 1/1/2000 90 5 RAP90 1/8/2000 90 6 RAP90 15/ 1/2001 90 6.5 RAP90 20/5/2001 90 6 RAP90 1/12/2001 90 5 RECEIPT SCHEME RECIEPT_DATE PERIOD AMOUNT FDR 1/2/2000 3 10000 RAP90 15/4/2001 90 15000 I want to computer to automatically renew the rec...
Pivot Table not pulling all fields or data
Hi All........ Without getting too verbose, I have a 900 row by 26 column database I am applying a Pivot Table to. The code seems to run fine, but it is not returning some of the fields, and of course the related data. I have tried reformatting the entire columns I am pulling from but no joy......however, when I reformat an errant cell from General to TEXT, that row comes in........and/or, if I change the value in one of the missing cells, it will bring that row in. The code runs fine, and was mostly derived by recording a macro in XL2k, but the data cannot be trusted becau...
Problem importing dll
Hi I have an application that used some external com dlls. So in my application code i've imported those dlls as #import "path of external.dll" and i'm using smart pointers to instantiate those coms as IExternaPtr Obj("External.Interface1"); The problem i'm facing that those external com dlls are not mine so every time they are modified by thier owner i've to recompile my code too with the latest dlls otherwise my code does not work and i get Obj = NULL in the above statement. Actually those external dlls are of a software that i've provided integratio...
How do I automatiicaly redefinie Source data range for a chart?
I have A Chart Defined by Category (X) values in Collumn B and Y values in Collumn C. Right now Both are defined by rows 4 to 114. I would like to be able to have the chart automatically redefine itself so if I put a value in C115 the chart would automaticaly set Y value range to be C4:C115 eithout having to manually define chart. Is this possible? If so how? I've tried OFFSET bu so far no luck. Hi, If you turn your data cells into a List, or Table in xl2007, the chart will auto expand. The named range approach will work if you set up the names correctly. See here for more info...
Problem with excluding an account from budget
I want to see my credit card payments (i.e., transfers to a credit accounts) as an expenses in Money reports. I know that I should exclude credit accounts from budget to achieve it, but it's impossible: - I'm going to Account Settings, and "Include this account in the budget planner" option is set - Trying to clear this option simply does nothing - it's still set and doesn't change. Is it possible that I've forgot something else to do before excluding an account from budget? If that's really your goal, the only sane way is to track them that way from t...
Exchange data backup
I'm worried emails backup of the small office. Does SBS2008 Exchange server has a direct backup capability of whole mail database? How to backup every night Emails from server to external harddisk? Does Exchange server needs to be stopped before backup? Thanks SBS2008 Takes care of it. http://blogs.technet.com/sbs/archive/2008/11/03/introducing-sbs-2008-backup.aspx look at the comments section Russ -- Russell Grover - SBITS.Biz [SBS-MVP] MCP, MCPS, MCNPS, SBSC Microsoft Certified Small Business Specialist 24hr SBS Remote Support - www.SBITS.Biz Question or Seco...
Data Save error
GP Ver 6.0. Recently I am facing an error with normal users unable to save records, where as the system administrator is able to save the same information. Please advice on this error, what has to be done. I have disabled the windows user ID of the Database owner. Thinking of this made Dynasa as the DBO. Database is having enough free space available. Hi How big is the company database? Is it over 10GB? Regards James "Matthews" <Matthews@discussions.microsoft.com> wrote in message news:3FF3F553-5B18-4D8A-B65E-8A253BF94BB2@microsoft.com... > GP Ver 6.0. Recently I...
extension DLL problems
I have CPropertySheet class with three CPropertyPage" classes in an extension DLL. I compile it, and run it. I get the .LIB and the .DLL files etc. in the client application I incluce the .LIB file and then I have add a button which when pressed will attempt to run the following code: CPropertySheet myWizard("Import wizard", this, 0); myWizard.DoModal(); this code produces the following error: "Debug assertion failed!" File: afxwin1.inl Line: 22 what is to be done? prg wrote: > I have CPropertySheet class with three CPropertyPage" classes in an > e...
Archive Problem
Dear All I work for an organisation that works in the dark ages. We use Outlook 98 (8.5.5603.0) with a basic build of NT4 (Service pack 6). When we use the archive functunality from the file menu we find that on some emails earlier than the date specified are not archived to the desired folder. I do not work for IT and cannot update service packs for outlook. Can anyone advise me what could be wrong? Was this a bug in this version. Sometimes some files would be archived and not all. What date is used? Is it the object's creation date? It makes no difference whether you have t...
Tab Control Problem
I'm just wondering how I can add controls to tab control pages that are bound to fields from different tables. I have 3 tables (road, track and gym) with similar named fields and I want to create a tab page for each table. Unfortunately, my tab control form only allows me to view and set controls for one table. So even though I might have a control bound to a field from table 'road', the information i enter goes to the table 'track' because that is the default table for the tab control form. My manual says I should be able to send and view info from different tables using ...
Outlook 2000 Folder Size Problem
I've created personal folders and rules for incoming mail. I've also deleted mail from Sent, Deleted Items, Etc. I think the problem is somewhere else...I checked the Folder Size for all of the folders under Outlook Today and the Total Size (Fld+SubFld): is 27900K. However, in the detail below, it does not add up to 27900K (only about 1200K). Could this be some kind of registry issue? I can't send email because the exchange server tells me that my box is full. Can anyone help with this? >-----Original Message----- >Hi Rob, >I take it that you are on an exc...
Problem Opening Notebooks on New Server
I have a small office and we all store and use notebooks on our server. We moved all of our data to a new server yesterday, and now when we try to open the notebooks we get a message that says: "OneNote needs a password to sync some of your notebooks", and we are unable to open the notebooks. Interestingly, if we open the notebook through a mapped drive to the location, we get the error. But, if we navigate directly to the notebook through the network, it will open with no error. We are having no other problems with this mapped drive. Thanks! ...
problem with starting thread
During debugging if we go over the following line of code: m_pCalculateThread = AfxBeginThread(UpdateDocThread, this); the thread DOES NOT start, but if we go into AfxBeginThread function, the thread DOES start. Any suggestions? Thanks in advance! Maybe you can look in the threads window during the debug. You could set execution to a thread using that too. "Leonid Nikolayev" <lenikn@gmail.com> wrote in message news:68e06e88.0409090843.e1b6c45@posting.google.com... > During debugging if we go over the following line of code: > m_pCalculateThread = AfxBeginThread(Upd...
Worksheet protection problem
I am using Excel 2000, wanting to protect certain cells, but allow user to filter using autofilter, etc. and how would I do this? Thanks, Jayne Private Sub Workbook_Open() Worksheets("Sheet1").EnableAutoFilter = True Worksheets("Sheet1").Protect UserInterfaceOnly:=True End Sub Right click on the Excel icon next to File in the menubar choose view code paste the code Alt-Q to go back to Excel This runs every time the workbook opens. It protects the worksheet and allows users to use the AutoFilter dropdown lists. -- Regards Ron de Bruin (Win XP Pro SP-1 XL2002...
cell range not changing when refreshing linked data- sumproduct fo
The cell range is not updating correctly to reflect the last row in the data sheet that is being refreshed. 5878 is the correct number of rows and 5824 is not. I can find and replace in my formulas to correct the problem, but it does it each time the data is refreshed. Any suggestions as to why? =(SUMPRODUCT((Expense!$B$2:$B$5878=$C$2)*(Expense!$C$2:$C$5878=$C$3)*(Expense!$W$2:$W$5824=$A6)*(Expense!$M$2:$M$5878))) I gave you the INDIRECT option y'day, but received no feedback from you in that thread. Looks like you're more interested in knowing why? One simple hunc...
Data vs. forms & Unload/reload questions
A .mdb file seems to encompass both the database and all the 'code' (forms, modules, and logic) used to CRUD the data in the tables. 1) Is there any way to separate the database from the code into separate files, eg. the db is mydata.mdb and the 'code is in a separate file, eg. code.mdb? 2) Say you have v1.0 of an app and the tables and attributes are populated with data. You then go and build v2.0 of the app, adding tables and columns to what already existed in v1.0, and perhaps moving some of the v1.0 attributes into different tables. What is the recommended way to unload/reloa...
Mobile Express set-up problem
After the installation, when I try to add some entities to the mobile application I get the following error: <?xml version="1.0"?> <configuration> <appSettings> <add key="DraftXmlLocation" value="C:\CrmMobileExpress\DraftXML.xml"/> <add key="PublishedXmlLocation" value="C:\CrmMobileExpress\PublishedXML.xml"/> <add key="Microsoft.Crm.Sandbox.Mobile.CrmServiceSdk.CrmService" value="http://triton:5555/MSCRMServices/2006/CrmService.asmx"/> <add key="Microsoft.Crm.Sandbox.Mobil...
Simple problem...
I am new to using Excel. I want to create a column that has the days of the month (1 Nov 03 thru 30 Nov 03). I know there is a way I can put the date in the first cell and then either paste or drag down and excel will add the dates sequentially, but I can't seem to figure out how to do it...I did it once before and don't remember the sequence that I followed. Could someone please post the steps on how to do this? Thanks! Bobby Bobby, put the date in a cell, A1, and click on the black square in the lower right hand corner and drag down -- Paul B Always backup your data before ...
csv-file problems with different regions
I have imported an American csv-file into a German Excel XP. The American $-values are separated by a "." while the German currency values are separated by a ",". So now my spreadsheet reads a value of $ 18.01 as 18. January. All values above 18.12 are ok. How can I avoid this problem? Or, can I change the values tediously one cell after the other? I have not found a way yet as even when I try to format a cell user defined it automatically changes to the format used in the German region. Thanks. Hans Temporarily change the regional settings on your computer to the same f...
Data Format: how can I re-format
The spreadsheet that was exported for me to use has the information in paragraph form: It is customer ID name and billing info but it is like a long series of address labels. I want to be able to have them listed under captions like company name, contact, address, city, etc.. so I can use the data. There is an empty row between each entry. Each entry is 3 or 4 rows. There are about 500 records so i dont want to manually set them up. Thanks Try tinkering around with these steps Assuming your list is in col A, data in A2 down (If data starts in A1 down, insert a new row for the co...
Help Problems with Outlook tool bar buttons
I'm hoping someone can offer advice on problems that I'm experiencing with Outlook 2003 toolbar buttons. Toolbar buttons usually work fine when I first open Outlook, but after I use a particular button once, it no longer works. For example, I can create a task, then assign the task. the next time I create a task, the assign button no longer works. I have to re-boot outlook to get the button to work again - then it only works once, etc, etc. This is also true of many other (but not all ) Outlook buttons, like "Save and Close", "Recurrence", and others. On...
Outlook Shutdown Problem
Office XP standard on XP Pro machine, in a Workgroup with a file server. Outlook works fine, however when closing Outlook, all indications are that it has closed, but opening Task Manager reveals that Outlook.exe is still running. If you try to shut puter down, Outlook "End Program" pops up. If you try to reopen Outlook, without killing in task manager, a second Outlook.exe pops up in Task Manager, but Outlook never opens. If you continue to click on Outlook icon, you can open a seemingly infinite number of Outlook.exe's. Have run "Detect and Repair" and have ...
Problems connecting to accounts
I am having problems downloading from most of my accounts. Some work but most do not, there is nothing I can do about this, is there? ...
Custom Type Charts Problem
I am using Custom Type Charts in Excel, which uses Pivot Table as the Data Source. The problem that I am facing here is that whenever I Refresh the data using the Refresh icon, the Custom Type charts LOOSE their formatting. To make my problem clearer, I am attaching a sample Excel sheet herewith. In the sample file, go to 3rd sheet "Custom Type Chart" and have a look at the "Tubes" chart. Now click on the "!" Icon (this is the Refresh icon). The formatting of the chart changes. Try this out with the "Normal Chart". The formatting remains the same. ...
Display comments as data #2
thanks a lot , this worked exactly as required, the comment go converted to data Now just one more thing . is the vice versa possible i.e if i have dat in column A can it be shown as comment in column B. the reason i need this is bcos i am shifting some data with thei comments to MS access(Hence the need to convert omments to data) processing them and again converting them to excel (the need to conver data back to comments -- sonik ----------------------------------------------------------------------- sonika's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=...