Issue with CSV file

I am programmatically creating a CSV file that has a list of formulae from a
workbook/worksheet (see example below).
Note that there are 5 records in the file, tho the text might wrap below in
your newsreader to appear to have more lines.
Double clicking on the CSV file causes Excel to issue #NAME? errors for the
records marked as BAD,

The records marked as "BAD" cause Excel to try to update the text due to the
included references to worksheets.
This occurs for a formula that begin with a "-" character. And, ditto for a
"+".
I can avoid the problem by sticking an apostrophe at the beginning of a
formula that begins with "-". or by multiplying by -1 at the end of the
formula.
I can avoid the problem by sticking an apostrophe at the beginning of a
formula that begins with "+". or by deleting the "+".

Is there a better solution?

"BAD","$I$11","-('123456789'!CurrentValue+'987654321'!CurrentValue+'00000'!C
urrentValue+Y17761492!CurrentValue+'123459876'!CurrentValue+Pizza!CurrentVal
ue)",
"GOOD","$I$12","('123456789'!CurrentValue+'987654321'!CurrentValue+'00000'!C
urrentValue+Y17761492!CurrentValue+'123459876'!CurrentValue+Pizza!CurrentVal
ue)",
"BAD","$I$13","-1*('123456789'!CurrentValue+'987654321'!CurrentValue+'00000'
!CurrentValue+Y17761492!CurrentValue+'123459876'!CurrentValue+Pizza!CurrentV
alue)",
"GOOD","$I$14","('123456789'!CurrentValue+'987654321'!CurrentValue+'00000'!C
urrentValue+Y17761492!CurrentValue+'123459876'!CurrentValue+Pizza!CurrentVal
ue)*(-1)",
"GOOD","$I$15","(-1)*('123456789'!CurrentValue+'987654321'!CurrentValue+'000
00'!CurrentValue+Y17761492!CurrentValue+'123459876'!CurrentValue+Pizza!Curre
ntValue)",


0
kaikow (53)
3/15/2008 4:25:32 PM
excel 39879 articles. 2 followers. Follow

0 Replies
532 Views

Similar Articles

[PageSpeed] 53

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...

Can Outlook emails be stored as a .eml file??
Hi, I'm wondering how does Outlook store emails when it is used as a mail client over the internet. Are the emails stored in .eml files as with outlook express? Thanks, Mark Outlook stores everything in a single .PST file - you can save individual messages as .msg or .txt etc, but not .eml Not sure what you mean by "used as a mail client over the internet" and how it pertains to file formats.... Mark wrote: > Hi, > > I'm wondering how does Outlook store emails when it is > used as a mail client over the internet. Are the emails > stored in .eml files as...

Auto Search When File Opens
Is there a way to configure a spreadsheet so it automatically comes up with the FIND tool as soon as the sheet opens? Thanks, Mark Is there a specific group of text that you want to find? A macro could be written to find it. Otherwise, try CONTROL F. "markmidwest" wrote: > Is there a way to configure a spreadsheet so it automatically comes up with > the FIND tool as soon as the sheet opens? > > Thanks, > Mark You can have a macro run each time that the workbook opens: Option Explicit Sub auto_open() Worksheets("sheet1").Select 'open to...

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 ...

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...

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...

hello everybody.. question about .CSV files.. 05-13-10
i have a excel .CSV file that Gmail generated for me with my contacts in.. what i want to do is function that go over all the contacts emails one by one and deletes all missformated addresses that cannot be use to send email for them.. somthing like : if (the cell's text is not an valid email address) { delete the cell ; } to be honest i dont know much about excel so i need somthing from scratch.. thank you all very much.. The trick being.............how will Excel know the cell's text is not a valid email address. Did you have some format in mind that...

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...

"file in Use"
Has anyone found a way to delete a file that is supposedly "locked for editing" by the only user on the computer? This usually seems to happen after a "page error" hangs the pc, and then the file (and its directory.... oops sorry "folder") can't be deleted - even in DOS I'm using Excel 200 under Win 98 Thank Kev exit excel go to the temp directory and delete all files there This should free it up. -- Regards, Tom Ogilvy "Kev" <northtasman@yahoo.com.au> wrote in message news:BC9292B3-33D9-4D76-A443-099AA7B90931@microsoft.com... > Ha...

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...

MacDolt file
I am taking a college class and need to prepare a problem using a MacDolt file. I have searched my excel to see if I have this file and can not find it. Can you please tell me how to find it for XP or how to download it from Windows? Thank you for any help from anyone. Regards, Minnieshell ...

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 ...

Deleting files
When using explore and I want to delete files from my 'c" drive I sometimes get the error code that I do not have access to the file. The system will not let me delete or even open the file. What can I do? Thanks Depends on what and where that file is. -- JoAnn Paules MVP Microsoft [Publisher] Tech Editor for "Microsoft Publisher 2007 For Dummies" "Jane M." <Jane M.@discussions.microsoft.com> wrote in message news:DF2C1380-D5B5-4AA3-A93C-33F9CA77A59F@microsoft.com... > When using explore and I want to delete files from my 'c&q...

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 ...

Show a CHM file
Is is possible to get a CHM file displayed inside a CHtmlView? When I do Navigate2("filename"), the window shows 'page not found' and opens the file download standard dialog. If I press 'open' the correct file opens, but in an external window! I want to show the CHM file inside my application in the window I have created for the job - is CHtmlView the wrong class to use? ...

How do I use a server name in an Excel chart file path?
Currently, I have a chart in my open workbook that was copied from an external workbook and I have changed all the file locations to match where the data is coming from in the original workbook. However, the source file is on a shared network drive on a server that is mapped under different names on each machine on the network. I have tried changing the links to the standard '\\server\drive\directory' format as shown below, but to no avail. The chart 'source data' dialog boxes do not allow this and say the "Reference is not valid. Reference must be to an open wo...

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 ...

How to block Zip files
I just noticed that outlook is letting users accept any file as long as it is in a zip file . I want to now block Zip files. How do I do this? You can do this by installing the admpack.exe available in the Office Resource Kit. Other options might be available on your corporate firewall or virusscanner. -- Robert Sparnaaij [MVP-Outlook] www.howto-outlook.com Tips of the month: -Backup and Restore -Create an Office XP CD slipstreamed with Service Pack 3 ----- "AlanM" <nooneatall@nowhere.com> wrote in message news:eUGllA9ZEHA.1840@TK2MSFTNGP11.phx.gbl... >I just noti...

Excel file is opened twice
I have Excel 97-SR2(m)on a Windows NT4 Sp6a workstation. Everytime I open an specific workbook this is opened twice. This file is located in a network folder. No macros in the workbook. Any idea about why this behaviour?. Thanks, Ivan.- If one has :1 at the end and the other has :2 at the end, then what has happened is that either intentionally or unintentionally, someone has used the feature Window / New Window which will allow you to see two copies of the same workbook at the same time (Can be very useful sometimes as you can tile the windows). When a file is saved in this mode it wil...

unprotect file: response to Truman's no help
I have password protected a file, and now that the untrustworthy employee is gone, need to unprotect it. When I click on 'Tools', then 'Protection', it doesn't offer the choice of 'unprotect...' as promised in HELP. The response to Truman's issue (posted 7/25 7:45 pm) was too complicated - I'm not an IT person. Any suggestions? Thank you! If you protected the file, you can save it again, without a password: 1. Open the file, entering the password when prompted. 2. Choose File>Save As 3. From the Tools menu, choose General Options. 4. Delete the ...

Shared file keeps losing connection
I have a shared workbook, and sometimes when I work on it, it seems to lose connection with the shared file. (as it happens, its a 2003 file operating on both 2003 and 2007, but I don't think that's related to the problem) The workbook has VBA modules in, nothing very complicated though. and I get the following message: 'You are no longer connected to this file. Another user may have removed you, or saved over it.' The file is always still there, and we haven't been removed. It is infuriating for everyone involved. Is there a way of getting it to automa...

.csv with double quotes
Worker in office has been "saving as" a csv file for well over a year. Suddenly when I save it now it creates a csv file that does NOT hav the quotes around each field as it had before. Not much information o Google about this. Even tried saving with CSV for Windows and CSV for Dos and both wit and without the Worksheet. Confused. Thanks, Pau -- SWMagi ----------------------------------------------------------------------- SWMagic's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2666 View this thread: http://www.excelforum.com/showthread.php?threadi...