Circular References

[thejamie]

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.

 

[Tyro]

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

 

[thejamie]

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