Search results for query: *

Just simple SUMIF functions. Worked ok in XP but not 2003. Just funny that if we save the sheets in Excel 2003 and change the Calculation option to Manual the #VALUE become the correct numbers.

Ken, Thanks for the reply. All the link files are valid files and plus we do need to update them upon opening. Just don't get it that the files worked fine in OfficeXP and now in Office 2003 just don't seem to work. Thanks!!!

Hi macropod, Simple ones just SUMIF. But if these are run on OfficeXP just the same they work, just after in 2003 just return #VALUE. Oh, as mentioned if I open those link source spreadsheets and just hit save they master file works. But surely this cannot be the final solution...

Hi, Macropod! Thanks for the reply. I wish it were that simple. I have been sratching my head about this one and just cannot understand why it is doing this. Any more thoughts or ideas? Cheers!!

Hi, I recently migrated from OfficeXP to Office2003 and upon openening my spreadsheets in Excel2003 those files with linked references to other spreadsheets only display in the cells #VALUE. However, if I goto those linked spreadsheets and open and save them then the #VALUE vanishes and the...

Hi, We run a macrotised spreadsheet that ran perfect in OfficeXP-Excel. We are performing some testing on Office2003-Excel and after the macros have run, when we try to paste in Excel we keep getting the message "Cannot Empty the Clipboard" Anyone have any ideas/solutions? Thanks!!

Hi, I just downloaded the Free SQL Server 2005 Express Beta 2.0 from microsoft. I have been trying to connect the SQL Server default "SQLExpress" endless times through the Server Explorer but with no luck. My .NET version is from 2001 will this make any difference? If I use the VB.NET 2005...

I've been trying to figure out how to use SQLConnection in .NET to connect to a Sybase server. Have been trying to read up on bits and pieces but nothing really explains how you can connect to them. Does anyone know what syntax I should use if I'm connecting to a sybase server i.e...

I was doing some testing using the ASP Application under VB.NET and created some Web Form Controls. However, when I went to view the page both in IE and the .NET browse mode. The web controls did not appear. Could someone tell me what is happening here and what I need to do to remedy this. I...

DotNetDoc, Many thanks for the tip and link. Thats a new one for me. I'll give that one a shot too. Thanks Canary

DocNetDoc, Thanks for the reply. However, I forgot to post the solution! I had originally declared the array as "Friend Product() as Object" and to set the size of the array I used the ReDim statement. Using this way always brought me the memory exception error...

In VB.NET I have a form that stores data into an array while it is loading. The form is a child form. When I click on the toolbar button to open it I keep getting the following error: An unhandled exception of type 'System.OutOfMemoryException' occurred in system.windows.forms.dll Additional...

I wrote a piece of testing code using an oleDB connection to connect to a sybase database (code as follows): Imports System.Data.OleDb sub connect() Dim PipeCon As OleDbConnection = New OleDbConnection("provider=sqloledb,data source=ABC_TEST," & _ "user...

We have been running some access applications, that call stored procedures on Sybase, under WinNT for a very long time now. Just recently we moved over to WinXP and all of a sudden those processes (calls to the stored procs) now prompt the user to login around 5-10 times instead of the once as...

Hi, I have created an automated print job that generates X amount of Microsoft Access XP Reports and creates them as PDFs and posts them to a web site for viewing. However, I recently upgraded to WinXP and found that everytime the PDF posts it prompts for the "Save As File Name&quot...

Wray, Tried the add-in, still did not work. The funny thing is that when I initially open the workbook and can see the numbers in the cells. Then when it asks me if I would like to update the links, I press no (saying that it will keep the displayed numbers) the cells turn to #NAME.

Already is set to "Save external.....". It's just so weird that when you open on 97 you can see the values. Then in XP they turn to #NAME. Strange!!!! I have rechecked it the main source cell that has a link i.e. ='L:\Buc\IBD\REGION\1998\NOV98\[WWRE2.XLS]FRONT'!$H$21+'ISG Adj'!M32...

The #NAME is coming from other cells that are referring to links that the sheets have been deleted. The formula is just +K27+K28 etc., nothing fancy. If I open the sheet in 97 it remembers the last values known to the linked sheets before they were deleted. But when opened in XP it does not...

I have a spreadsheet created from Excel 97 containing various links. Some of those linked spreadsheets have been deleted. However, when openend in 97 it still keeps the previous values. But when I open in Excel XP, those linked cells (where the spreadsheets no longer exist) displays as #NAME...

Many thanks for your help. With the info you gave me I can now explain to my people why this is happening. I guess my only current option is to get our users to repair them when opening them in OXP. Thanks