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.
--
Regards,
Jamie