Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 - Don't Update Issue
I'm currently using Excel 2003 in WindowsXP. The problem is the following: I
have 2 Excel files (A and B) which they linked to other files (LinkA and LinkB) respectively. When I open the first file Excel prompts me to update the file or not. Then, I click Don't Update and so far so good. However, when I open the second file which also has a link to another file (linkB) and it asks me to update or not the file and I select Don't Update, File "A" changes its formula results even though file A and B are not linked with each other at all. The interesting part is that File "A" changed the formula results to a number that doesn't make any sense. So I need to go to Edit Links Update Links to fix the formula results again. The only way I've found to go around this issue is by opening the files in separate Excel sessions. If anybody knows where I could find a patch for this issue I would appreciated. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 - Don't Update Issue
Very difficult to find the problem without looking at the files or some
examples of the formula in A which get updated and what they get updated to. Pl. post 2-3 examples... What happens if 1. You chose to update? 2. If you open the file in reverse order? Try renaming file B and then open A followed by B as you have been doing... Let us know what happens. "ElDorado" wrote: I'm currently using Excel 2003 in WindowsXP. The problem is the following: I have 2 Excel files (A and B) which they linked to other files (LinkA and LinkB) respectively. When I open the first file Excel prompts me to update the file or not. Then, I click Don't Update and so far so good. However, when I open the second file which also has a link to another file (linkB) and it asks me to update or not the file and I select Don't Update, File "A" changes its formula results even though file A and B are not linked with each other at all. The interesting part is that File "A" changed the formula results to a number that doesn't make any sense. So I need to go to Edit Links Update Links to fix the formula results again. The only way I've found to go around this issue is by opening the files in separate Excel sessions. If anybody knows where I could find a patch for this issue I would appreciated. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 - Don't Update Issue
Same problem.
Same issue. Keep in mind that the files are not linked to each other. If I click "Update" then the file updates its data correctly. The problem is when I click Don't Update in both files. A lot of the times I don't want to update the files, so I have to open another Excel session (by clicking on the Excel icon) to open the second file, thus avoid this issue. The problem is that it's very cumbersome having to open the file in different sessions. It seems like this problem happens on and off. I've tried to pinpoint the cause of it, but I can't figure it out. It happens with files with macros and file w/o macros in it. "Sheeloo" wrote: Very difficult to find the problem without looking at the files or some examples of the formula in A which get updated and what they get updated to. Pl. post 2-3 examples... What happens if 1. You chose to update? 2. If you open the file in reverse order? Try renaming file B and then open A followed by B as you have been doing... Let us know what happens. "ElDorado" wrote: I'm currently using Excel 2003 in WindowsXP. The problem is the following: I have 2 Excel files (A and B) which they linked to other files (LinkA and LinkB) respectively. When I open the first file Excel prompts me to update the file or not. Then, I click Don't Update and so far so good. However, when I open the second file which also has a link to another file (linkB) and it asks me to update or not the file and I select Don't Update, File "A" changes its formula results even though file A and B are not linked with each other at all. The interesting part is that File "A" changed the formula results to a number that doesn't make any sense. So I need to go to Edit Links Update Links to fix the formula results again. The only way I've found to go around this issue is by opening the files in separate Excel sessions. If anybody knows where I could find a patch for this issue I would appreciated. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 - Don't Update Issue
In some files, I do have a Workbook_Open Macro to Password Protect the file
automatically when the file is opened. I wonder if that has anything to do with it. Here is the code: Private Sub ProtectSheetsPwd() ThisWorkbook.Activate For Each Sh In ThisWorkbook.Worksheets Sh.Protect Password:="xxxxxxx", _ DrawingObjects:=True, Contents:=True, Scenarios:=True, UserInterfaceOnly:=True, _ AllowFormattingColumns:=True, AllowFormattingRows:=True Next Sh For Each Sh In Sheets(Array("Template", "Assumptions", "Index")) Sh.Visible = xlVeryHidden Next Sh End Sub "ElDorado" wrote: Same problem. Same issue. Keep in mind that the files are not linked to each other. If I click "Update" then the file updates its data correctly. The problem is when I click Don't Update in both files. A lot of the times I don't want to update the files, so I have to open another Excel session (by clicking on the Excel icon) to open the second file, thus avoid this issue. The problem is that it's very cumbersome having to open the file in different sessions. It seems like this problem happens on and off. I've tried to pinpoint the cause of it, but I can't figure it out. It happens with files with macros and file w/o macros in it. "Sheeloo" wrote: Very difficult to find the problem without looking at the files or some examples of the formula in A which get updated and what they get updated to. Pl. post 2-3 examples... What happens if 1. You chose to update? 2. If you open the file in reverse order? Try renaming file B and then open A followed by B as you have been doing... Let us know what happens. "ElDorado" wrote: I'm currently using Excel 2003 in WindowsXP. The problem is the following: I have 2 Excel files (A and B) which they linked to other files (LinkA and LinkB) respectively. When I open the first file Excel prompts me to update the file or not. Then, I click Don't Update and so far so good. However, when I open the second file which also has a link to another file (linkB) and it asks me to update or not the file and I select Don't Update, File "A" changes its formula results even though file A and B are not linked with each other at all. The interesting part is that File "A" changed the formula results to a number that doesn't make any sense. So I need to go to Edit Links Update Links to fix the formula results again. The only way I've found to go around this issue is by opening the files in separate Excel sessions. If anybody knows where I could find a patch for this issue I would appreciated. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 - Don't Update Issue
Does anybody have an answer for this problem? Thanks!
"ElDorado" wrote: In some files, I do have a Workbook_Open Macro to Password Protect the file automatically when the file is opened. I wonder if that has anything to do with it. Here is the code: Private Sub ProtectSheetsPwd() ThisWorkbook.Activate For Each Sh In ThisWorkbook.Worksheets Sh.Protect Password:="xxxxxxx", _ DrawingObjects:=True, Contents:=True, Scenarios:=True, UserInterfaceOnly:=True, _ AllowFormattingColumns:=True, AllowFormattingRows:=True Next Sh For Each Sh In Sheets(Array("Template", "Assumptions", "Index")) Sh.Visible = xlVeryHidden Next Sh End Sub "ElDorado" wrote: Same problem. Same issue. Keep in mind that the files are not linked to each other. If I click "Update" then the file updates its data correctly. The problem is when I click Don't Update in both files. A lot of the times I don't want to update the files, so I have to open another Excel session (by clicking on the Excel icon) to open the second file, thus avoid this issue. The problem is that it's very cumbersome having to open the file in different sessions. It seems like this problem happens on and off. I've tried to pinpoint the cause of it, but I can't figure it out. It happens with files with macros and file w/o macros in it. "Sheeloo" wrote: Very difficult to find the problem without looking at the files or some examples of the formula in A which get updated and what they get updated to. Pl. post 2-3 examples... What happens if 1. You chose to update? 2. If you open the file in reverse order? Try renaming file B and then open A followed by B as you have been doing... Let us know what happens. "ElDorado" wrote: I'm currently using Excel 2003 in WindowsXP. The problem is the following: I have 2 Excel files (A and B) which they linked to other files (LinkA and LinkB) respectively. When I open the first file Excel prompts me to update the file or not. Then, I click Don't Update and so far so good. However, when I open the second file which also has a link to another file (linkB) and it asks me to update or not the file and I select Don't Update, File "A" changes its formula results even though file A and B are not linked with each other at all. The interesting part is that File "A" changed the formula results to a number that doesn't make any sense. So I need to go to Edit Links Update Links to fix the formula results again. The only way I've found to go around this issue is by opening the files in separate Excel sessions. If anybody knows where I could find a patch for this issue I would appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
EXCEL 2003 Export Issue | Excel Worksheet Functions | |||
Excel Issue: Links within a Workbook don't appear to update | Excel Discussion (Misc queries) | |||
Excel 2003 memory issue | Excel Discussion (Misc queries) | |||
Issue with Excel 2003 | New Users to Excel | |||
excel 2003 issue | Excel Discussion (Misc queries) |