 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / General Excel Questions / March 2008Circular References
I have a csv file saved in 2003 on a laptop. The laptop is the office laptop and when I am home, I access my home network from that laptop using a wireless that is, in a sense, in a DMZ for a Small Business Server network. I log into the home network using an RDC over VPN. The VPN is established from the wireless in my home which runs on a separate network. Sorry, I know that doesn't belong in this question about circular references but I don't want a simple answer here. I created a csv file on the laptop and then copied it over to the Network machine where I tried to open it in Office 2007 Excel. When I open it, there are about 1000 circular references. Obviously too many to fix. When I open the same file on the laptop in Office 2003 there are no circular references. Meanwhile, I noticed that my firewall (Zone Alarm) went into a total shutdown. I have never seen Zone Alarm fail by itself. Using the system will crash around it. Guess Zone Alarm is gettting better. Question is, can I remove the 1000 or so Circular References easily? I can do them one at a time by reading the information, deleting it, moving to another cell then moving back and reentering the information in the cell. But I have no intention of doing it a thousand times or more. Also, why would Excel show that the file itself was locked down by the other machine where it was copied from even though the file was not open on that machine? There was a message box stating that I could receive a notification as soon as the file was released. I went back to the other machine and even though the file was closed, EXCEL still showed up in the processes (Task Bar). When I killed the EXCEL process, the notification came on to tell me the file was release. So this brings me to another question... is Zone Alarm locking down the EXCEL file when it gets copied over from one machine to another? It would do that if it were tracking the IP and the network access for trust. Trust exists for the hone Small Business server network. It does not exist for the wireless LAN that the laptop is on. How can EXCEL possibly have become this complicated to run? What do I do? Have to reboot now... Zone Alarm is mad at my machine.  SignatureRegards, Jamie You can begin to solve the problem very simply. If the workbook is fine in Excel 2003, copy it to a CD and then open it on the other machine with Excel 2007. If it is again fine, it's not Excel causing the problem. Tyro >I have a csv file saved in 2003 on a laptop. The laptop is the office >laptop [quoted text clipped - 43 lines] > > What do I do? Have to reboot now... Zone Alarm is mad at my machine. ots of options. But the one that is important to me is for a method that removes the circular references. The original document is a single CSV sheet which does not contain any. It is clean data entry ready to be imported into a database. Truly, there has to be some way to remove ALL circular references. Since the laptop does not have a burner nor floppy and since I have no response on how to remove all the circular references, I tried to create a disk on an ISO with the EXCEL file, but because there is no physical burner on the laptop, even loading burner software and trying to burn an ISO to a DAEMON did not work... so, your idea might work, but I have doubts that it is anything but the EXCEL 2007. It actually makes sense that this would happen as the network ties the profile into the mix with the documents... the Shadow copy on the server tracks it - I suspect this is a combination of the shadow copy from the server and the document tracking inherent to EXCEL ole. I simply reloaded the source and saved it to a server share and then copied from the server share. That fixed the problem. I'm annoyed that something this simple should be this complicated. SignatureRegards, Jamie > You can begin to solve the problem very simply. If the workbook is fine in > Excel 2003, copy it to a CD and then open it on the other machine with Excel [quoted text clipped - 49 lines] > > > > What do I do? Have to reboot now... Zone Alarm is mad at my machine. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.