Solved

Removing data only; save formula

Posted on 2013-06-13
3
266 Views
Last Modified: 2013-06-13
I'm starting a new fiscal year and need to remove all the data from the current fiscal year; but save all the formula's.

I used F5; Constants and was successful at removing most of the data; but some some .

I'm sure it has something to do with the Details list data, ut I deleted the data on that page, so why is the data still showing up in the Master sheet?
Master-Budget-with-locked-data.xlsm
0
Comment
Question by:mikecox_
[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
3 Comments
 
LVL 12

Accepted Solution

by:
duttcom earned 500 total points
ID: 39246281
There are still 6 rows with data at the top of the tbl_Details table on the Details sheet.
0
 

Author Comment

by:mikecox_
ID: 39246326
Oh!!  It opened with those out of site; never occurred to me to scroll down!
Thanks
0
 

Author Closing Comment

by:mikecox_
ID: 39246327
Thanks
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
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 Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

632 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