Issues - ghost data

I am having ghost data appear randomly in my workbook while trying to clear 
data. The workbooks are large and contain multiple macros. When clearing a 
feild, Other ghost-like images of cells and data pop-up randomly and clutter 
my view. This is a new computer running windows 7 and excel 2007. IT has 
already updated my video driver and we are all stumped. 

Please respond quickly with ideas...they are threatening to give me back my 
old computer....
0
Utf
3/22/2010 6:21:02 PM
excel.misc 78881 articles. 5 followers. Follow

0 Replies
979 Views

Similar Articles

[PageSpeed] 36

Reply:

Similar Artilces:

Format issues
I have created a template in word which I call through a VB script from excel. The excel data is populated in the word every time I run this script. Everything works fine and the data get populated. I have a header in the template which is represents one of the fields in the excel sheet. The header shows the correct linked value for the first 10 pages but then on shows the variable name instead of the value. I have no idea why it does that? can someone help The code is as follows: For iCurrentRow = 1 To iLastRow If ActiveSheet.Range("B" & iCurrentRow...

HELP! HTML Emails with mailto: forms in send data as an attachment!!
Hi, I am a developer and I have a windows service which uses a database to send emails. The emails are in HTML format. Some of them have <FORM action="mailto:[an email address]" enctype="text/plain"> in, so that data input into the emails form can be emailed to a specific person. This works fine with Outlook Express in that when the address in the action="" of the form gets an email, they see the forms data in plain text, (as they should). HOWEVER! If someone with Outlook (2002) fills out the form and sends it the recieved email has the form data as an a...

Outlook issues after Exchange migration
We recently migrated Exchange 5.5 mailboxes to Exchange 2003 on a new domain. This was performed with the exmerge utility in a 2 step process. Now there are 2 issues with Oulook: 1) When a user types a recipient name into the address field, the name autocompletes as normal. But when the mail is sent, a message returns saying it is undeliverable. However, if the user goes into the Contacts folder and from there selects the same user to send a message to, it is successful. 2) If a user shares a calendar, specifying the user with whom to share and the level of permissions, all users in ...

Editing Chart Data Table
I have a bar chart with 2 different series of data (Item cost in $, and % of total volume delivered). I want to create a data table under the chart, but have it only show the values for the volume delivered and not the item cost. Is there a way to exclude data from the data table? Thanks. ...

Drop-Down Menus in Data Entry Form?
I have a drop-down menu containing the months of the year in my spreadsheet. I want to train people to enter data using the data entry form (Data --> Form). Is there any way to make this drop-down menu appear in the data entry form? You could create a macro that displays the data|form dialog. But when would you want to run that macro? When the workbook opens? When the worksheet is activated? Only when the user wants to see it? The line of code could be as simple as: ActiveSheet.ShowDataForm "patryan22@aol.com" wrote: > > I have a drop-down menu containing...

Taskbar issue
Hello All I'm hoping someone can help me with this long-standing problem with both XP and Vista on separate laptops and every computer I've had (except I think Win98). I'm thinking there may be no solution, but what it's worth a try. With both of my machines, I have the taskbar (as well as other toolbars) set out to maximum size - typically half the screen - and to auto hide. (This makes a great program and file launcher) The issue is that the operating system decides it wants open the taskbar on its own from time to time on its own. Various things prompt this, ma...

'access data on web'
With prior versions of Money, synching w/ the web would (apparently) simply copy data from the Money file to a page behind your login at MSN. I appears that has changed. It looks like MSN is itself going out and downloading information from financial institutions and then that information is updating my Money file. What is actually happening when I elect to make my data accessible on the web? I just want to have my Money stuff copy to my MSN login...is that possible? IF you don't enable transaction download from an FI that is only accessible via a "third party" (Yodlee ...

DST issue
I entered the catalog item: <Feature Name="Item" CatalogItemId="Item:MS:sysgen_timesvc_dst" /> and confirmed that the device has the registry key: HKLM\Software\Microsoft\Clock\AutoDST = 1 But the device still does not automatically adjust for DST. I set the timezone to Pacific, set the time to 3/14/2010 at 1:59AM, waited for one minute...and the time changed to 2:00AM instead of 3:00AM. What am I missing? Thanks. which OS version are you using? have you updated it with the relevant qfes which deal with the changing in DST starting day? -...

Outlook/EX Email Issue
I'm running Windows XP with XP Professional. I cannot send email but I can recieve it using Outlook. There error says that Outlook was unable to access the SMTP server. I cannot access my email at HOME through the web email. What I can do is send/recieve email using Outlook Express AND I can access my email through my web email client outside my home. My ISP (SBC) says its not them and I'm somewhat inclined to agree with them? They say I could have a corrupted kernel32.dll file. I have turned off my Norton, deleted my account and set up a new one and re-installed XP professiona...

Data Validation #2
Basically there are three categories from which the user can selec from. Eg Issues Sub-issues Services-issues - servicing - assessing - delay in assessing - call centre - misquote - information - website (no entry required) - brochure I would like the sub-issues and services-issues to depandant on th issue first chosen, thus limiting the selection on the subissue an servicing-issues drop down. Is this possible in Exce -- Message posted from http://www.ExcelForum.com Hi Pascale check out Debra Dalgleish's site espe...

Extender Install Issues
GP 8.0 Extender install - I'm encountering the following: *Login to GP brings up screen: "Great Plains Extender needs to finish installing. This may take a few minutes". It has an OK button and clicking on this gets you into GP but it comes up everytime. How can we stop this from popping up all the time. *When creating a new Extender Window and I get select the Form, I get the following error: "A remove range operation on table 'PT_User_Defined_Window_Keys' failed accessing SQL data." Procedure or function zDP_EXT40101L_1 has too many arguments spec...

Data Source of Pivot table
Hi NG if i create a Pivot table with the Wizard in Excel 2000 and have my data in a ACCESS 97 table, where can i see the explicit Path and name of the database and the table that are concerned. if the place of the database changes, is it possible to write this change directly into to excel-File via VBA to tell him, that the refresh has to be taken from a different database. maybe the access-table-name could be changed also, on the bassis, that the structure stays the same. Thanks for helping Regards Reiner ...

Possible Report Issue
Hi. I'm working on a database for a safety audit. The auditors would like to be able to use some of the tables and subtables as a sort of checklist for the audits. The table/subtable structure is as follows: Topic -->Subtopic -->ProgramArea -->ProgramRequirement I decided to create a report that will output that data. However, the report is only outputting information if there are ProgramRequirements already entered for a given ProgramArea. Is there a way to get it to output the ProgramArea and ProgramRequirement even if blank? Or am I going about th...

using excel form to input data into access
Is it posible to use an excel spreadsheet to enter data into access? please reply to group You can link access to Excel. But why? before going any further, explain the reason why you would want to do this. Let us evaluate what your needs are. Access Forms are much better for data entry, for a number of reason, than Excel. What would you use acces for then if your data is being entered and stored in Excel? Explain some more so we can guide you better. -- Hope this helps, Daniel P "billb" wrote: > Is it posible to use an excel spreadsheet to enter data into acces...

How to get data from Beta to BCM Trial
I have the trial and now have lost all my BCM data. I was getting the following until I deleted the BCM portion that was being loaded. Outlook 2007 trial small business. On start up I get three error messages that data entered in the beta cannot be opened in the contact mgr. So I say ok to all and Outlook opens. When I click on the business contact mgr folder under all mail items I get the above error message. Help? How do I get all my data back? I also can't get anyone to respond so I am putting this everywhere! ...

Adobe issues
We are running GP 9.0, using Windows 7, just installed Adobe 8.0 and are unable to send documents to PDF from GP - the PDF option remains grayed out. We have folowed the KB articles that are available, no success. Do we need to install Adobe 9.0 due to running Windows 7? Is GP 9.0 compatible with Adobe 9? Thank you for any assistance.. Hi Susan, I have a client using Adobe 9 on Windows 7. However, they are on GP 10.0 It is working succesfully. -- Geoff James "Susan" wrote: > We are running GP 9.0, using Windows 7, just installed Adobe 8.0 and are ...

Issue with formula is Pivot table
I have the following formula in a pivot table: =IF(ISBLANK(Qtr[-1]),IF(ISNUMBER(Qtr[-2]),(Qtr[-2]*-0.08)+Qtr[-2], "),IF(ISBLANK(Qtr[-2]),0,Qtr[-1])) First to the issues that I am experiencing. First, the formula wa originally added as the one below but then updated to the formula abov to correctly reflect what I was trying to accomplish. =IF(ISBLANK(Qtr[-1]),IF(Qtr[-2]<>0,(Qtr[-2]*-0.08)+Qtr[-2], "),IF(ISBLANK(Qtr[-2]),0,Qtr[-1])) This issue is the original formula appears in the very first cell o the pivot table and then periodically through out the column. So, yo see ...

Outlook Web Access OWA Issue - Login Prompt for Images
Dear Outlook 2003 / Exchange 2003 Users, Starting over the last two weeks (possibly after an update on the Exchange server), all of my users are starting to encounter the same issue when using Outlook Web Access (using IE6 on XP Pro systems). We have images in our signature block, and now when someone replies using Webmail to an e-mail originally sent via Outlook 2003, a login prompt appears for each image in the e-mail. Every time you cancel the login box, a red x image box appears, until all of the images that should be there are represented by the red x boxes. For the record, this has w...

Hyperlink Issue #2
I have an issue with hyperlinks. When you click on the hyperlink on a webpage it returns an error stating that the the "item could not be created". Outlook 2000/Windows 2000 ...

No data return from a sub-query causes an error message
I have a sub-query which counts the number of referrals received [Date Received]. The user then enters the criteria of the time period between [start date] and [end date] and the locality [Town]. There are 9 different localities. When the query is run and there have been no referrals in a particular locality, the table appears as column headings with no data. The query that this links into (as do several other sub-queries) then also returns no data. How can I get the first sub-query to return data for each of the different localities, with 0 if there have been no referrals? If someone ca...

Update Issues
Has anyone experienced any problems with XP Pro updates sent in Feb.? My Lenovo T61p has performed flawlessly for 2+years but suddenly started turning off and now stays on but freezes-up. I can’t detect a virus and seems like the Feb. updates are all that has changed. I plan to uninstall them….between freeze-ups, unless someone has a better thought. Thanks >Has anyone experienced any problems with XP Pro updates sent in Feb.? My >Lenovo T61p has performed flawlessly for 2+years but suddenly started turning >off and now stays on but freezes-up. I can�t detect a ...

~ issue
I am currently using Outlook Express 6 and have noticed that for the second time (did a format the first time thinking I had a virus!) that when I have downloaded the 330994 April 2003, Security update for Outlook Express 6 SP1 that anytime I make a change to my address book and reboot I get an icon on my desktop that is named "~" and it basically is my entire address book. Has anyone else experienced this problem and how do I remedy it? Thank you for any help! Sue In reviewing the Outlook Express newsgroups, this is reported as a known issue w/ no fix from Microsoft (report...

Plot Line in data table
I have a table of data 8 9 10 11 12 13 14 15 1.00 28 32 35 40 47 59 71 82 1.50 42 47 53 60 71 88 106 123 2.00 56 63 70 80 94 115 141 184 2.50 70 79 83 100 115 147 176 206 3.00 84 95 105 120 141 176 212 247 3.50 98 111 125 140 165 206 247 288 4.00 112 128 140 160 188 235 282 329 4.50 126 142 158 180 212 265 317 370 5.00 140 158 175 201 236 294 353 411 5.50 154 174 193 221 259 323 388 452 6.00 168 189 211 241 283 353 423 493 I want to be able to plot a line through this for a specific value. Is this possible. eg if i wa...

Multiple Outlook Mailboxes issues with 3.0
I have a large number of users who have more than one outlook mailboxes, When I open an email from one of the addtional mailboxes, I get an error message that tells me "Only Items in the default Outlook store can be promoted to Microsoft CRM." Does anyone know if this can be worked around?? ...

Chart with mixed annual/5 year data
I'm doing a simple line chart where several data series are on an annual basis but one has figures only for every fifth year. I entered the fifth-year numbers in a column alongside the annual data and left blank cells in between. When I added that series to the chart it shows up in the Source Data window and in the legend on the chart, but no data points are in the chart. I'm sure I'm doing something stupid here, but does anyone know how to fix this? Thanks! ...