?
Solved

Excel wants me to save... No changes made

Posted on 2003-03-27
6
Medium Priority
?
224 Views
Last Modified: 2009-12-16
I have a spreadsheet which, when opened, opens fine.  However, when I want to close the spreadsheet, it always asks me if I want to save it..

"Do you want to save the changes to..."

I am using Microsoft Excel 2002.  This does not happen on other spreadsheets.  I see no code in VB, the selection for !Refresh Data is greyed out, so I am assuming that there is no external data coming in..  However, there are little green triangles in the upper left hand corner of several cells which leads me to believe that there is external data.  If this is the case, how can I tell where the data is coming from.

Also, how can I force excel not to ask that question for this spreadsheet??

Thanks in advance!

Andrew Mueller
0
Comment
Question by:kwblue
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
6 Comments
 
LVL 9

Expert Comment

by:pauloaguia
ID: 8220443
Maybe you have that quesry table set to automatically refresh when the file opens? If so then the workbook would be changed and the question is explained.

You can see the properties for the Query Table by right clicking it and selecting "Data Range properties" from the menu that pops up.

Paulo
0
 
LVL 9

Accepted Solution

by:
pauloaguia earned 100 total points
ID: 8220453
By the way, if this is the problem, all you have to do to solve it is uncheck both the "refresh every xx minutes" and "refresh on file open" checkboxes.
0
 
LVL 1

Expert Comment

by:Howler_Fish
ID: 8222161
Hi,  a thought but not necessarily the answer.  In my experience the little green triangles are usually when Excel wants to change the formatting of a cell, but is unsure.  For me this is usually because it has received a text string that is pure numeric (eg "2341").  It wants to convert this to a number rather than keep it as a text string.  Perhaps it is this conversion that is causing the problem.

HF
0
 
LVL 2

Assisted Solution

by:abdriver2000
abdriver2000 earned 100 total points
ID: 8223054
You may be having system dates somewhere in the worksheet. This changes everytime when you open the file. Hence, Excel asks you to save the changes. Check if your excel sheet uses =NOW() function.
0

Featured Post

Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
This video shows where to find the word count, how to display it, and what it breaks down to in Microsoft Word.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question